Formatting large number to display rounded $

[brad_x81]

In cell S2, I have a large number (formatted as number) and I need it to stay that way = 120800000

In the next column I am trying to make the number appear as, $ 120.8M

Formulae =IF(S2>=1000000000,TEXT(S2,"$ #.,,,")&"B",IF(S2>=1000000,TEXT(S2,"$ #.,,")&"M",IF(S2>=1000,TEXT(S2,"$ #.,")&"K",TEXT(S2,"$ ###"))))

However in T2 - it appears as $ 120.M - missing the 8 out.

Any ideas on where I am going wrong in the above function?

Thanks.

[brad_x81]

Sorry forgot to mention - and the same if number is; 11419648000

It is appearing as $11.B - Ideally I would like it to say $11.4B.

[Special-K]

Try

$#.##,," M"

Source: http://www.techrepublic.com/blog/mic...read-millions/

[brad_x81]

Ah that seems to have done the trick!

Thanks