It seems odd that the last post on this subject was Mar '16 so maybe others are not having this problem or maybe no one has negative numbers in their report but we are not all that lucky so I am revisiting this topic now.
-latest Manager desktop v. 17.7.52
-excel 2007 (old but still works for me)
-Windows 10 Pro
-Profit & Loss
-Statement of Changes in Equity
In all of these report a negative number is prefixed with "− " as in “− 10”. This results in a text field which is very difficult to convert to numeric in excel. So what is the problem?
In excel a negative number starts with
"-" whereas, as noted above in a report copied with the Export feature a negative number starts with
"− " if you look closely you will see these are not the same.
The "− " generated by Manager has two problems. 1. There should be no space between the dash and the first digit. 2. the dash (notice I do use a term related to negative numbers) is not the ASCII symbol for a negative amount which is #45. I could not discouver the ASCII code for Manager’s dash but it is not #45.
Workaround, in case any reader is interested.
In excel do an in-cell edit and copy the "− " (not the quotes of course), and then do a Find and Replace finding "− " and replacing with “-”. This will make all of the negative as text amounts numbers that excel can use. Please note you can’t type in the Find part as, on my key board at least, the dash does not exist.
Correct the programming as I seriously doubt any spread sheet or accounting program deviates from the ASCII norm for a negative sign.
If I am dead wrong with all of this please let me know.