Posted by Bob A on June 14, 2012 at 12:44:09:
In Reply to: Negative numbers in Excel posted by Jim Barbaruolo on June 14, 2012 at 09:45:25:
I guess if SAP formats negative numbers with the minus on the right... soon Excel will be pre-programmed for it... until then:
Mirror Negatives
Anyone that has worked with imported numbers in Excel will often be left with the problem of imported negative numbers that have the negative sign to the right of the number. These are referred to as mirror negatives. This means Excel will not see your numbers as negative numbers and to make matters worse, it won't even see them as valid numbers.
SAP is one such program that does this with negative numbers, e.g 200- instead of -200.
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.