woops,

I mean

[=1000000000] $#,###,, "Billion";[=1000000]$#.0,, "Mil"; $#, "k"

But 1,965,532 will round up to 2.0 mil because 60,000 is rounding up causing
900,000 to round up to the next mil

1,945,532 should round to 1.9 mil.

HTH,

Conan





"Conan Kelly" wrote in message
...
coastal,

How about this?

[=1000000000] $#,###,, "Billion";[=1000000]$#.#,, "Mil"; $#, "k"

HTH,

Conan




"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