View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
coastal coastal is offline
external usenet poster
 
Posts: 25
Default Custom Number Formats - Billion Dollars Rounded

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