Hi, I have a loads of numbers on my excel document and am coming across an error.
(Window 8)
This is my Format:
[>=1000000000]$#.0," B";[>=1000000]$#.0," M";$#,##0
Theese are the results
1234 = $1,234
1000000 = $1.0 M
1000000000 = $1.0 B
-123 = $123 ???
The negative is not showing