Dear Team: for some Chart Reports we import data to spreadsheets, but Numeric Figures are not Recognized and unable to have SUM and also can not Filter them.

this is a function of your spreadsheet program. change the format to numbers for the column.

@sharpdrivetek all ready checked. not working, spreadsheet is working properly.

then you will need to explain in detail the exact reports you are having trouble with. also, post screenshots to understand better.

Just Copy to Clip Board all DATA on Spreadsheet [image] [image]

like i already said this is an issue with your spreadsheet program. i checked the same report and i do not find any such issues in my MS Excel program. make sure your system uses the same number format you have set in Manager. also, the Sales Invoice Totals by Customer report already displays the…

The numbers are being imported into the spreadsheet as text not numbers. If you try and do local calculation or format the cells as a number, the numbers will probably show with a proceeding quote mark indicating they are stored as text not as a number. Note also the numbers are not aligning right…

To get more precise help, you should say What version of Manager you are using What language you are using What number format you are using in Manager Operating systems you are using What your region number format is What spreadsheet program you are using What number format is the default in the s…

@Joe91 [image] Joe91: What version of Manager you are using Cloud [image] Joe91: What language you are using English [image] Joe91: What number format you are using in Manager [image] [image] Joe91: Operating systems you are using Windows [image] Joe91: What your…

@Patch thanks for your reply. :+1:

I am using Manager 21.9.23 Desktop Windows 10 [image] When I use the Copy to Clipboard and Paste into Excel I get [image] So it works perfectly for me. Must be something in you spreadsheet setup ?

Numeric Figures are not Recognised

AJD September 22, 2021, 1:21am 17

This thread may also be of assistance, especially the posts about system regional settings.

Topic		Replies	Views
Data is neither text nor number	23	863	September 4, 2021
Issue with copy to clipboard	15	704	January 6, 2023
Copy and paste	84	1572	May 30, 2021
Copying Data to Excel - Numbers has Paragraph Returns	29	1579	October 26, 2021
Format issue with Copy to clipboard	8	434	March 13, 2023

Numeric Figures are not Recognised

Related topics