Custom Number Formats - Billion Dollars Rounded
Thanks!
--
--coastal
"Tyro" wrote:
Just noticed your format for billion is wrong. It's formatting 1.5 Billion
as 1,500 Billion. Try this:
[=1000000000] $#,##0.0,,, "Billion";[=1000000]$#0.0,, "Mil"; $#, "k"
Tyro
"Tyro" wrote in message
...
[=1000000000] $#,###,, "Billion";[=1000000]$#0.0,, "Mil"; $#, "k"
"coastal" wrote in message
...
Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.
[=1000000000] $#,###,, "Billion";[=1000000]$#,, "Mil"; $#, "k"
The above will formatt this $1,965,532 into this $2 Mil
But will also formatt this $1,838,928 into this $2 Mil
I need to adjust the custom number formatting so that I get the following
instead
$1.9 Mil
$1.8 Mil
Any suggestions?
--
--coastal
|