Negative Formatting Error

asked 2015-06-28 09:54:37 +0200

updated 2015-08-25 07:41:56 +0200

Alex Kemp gravatar image

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

edit retag flag offensive close merge delete