View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Convert number to Million Currency format

I'm not sure that works correctly (my XL2003 SP3 version removes the comma
and outputs 4 decimal places). This one seems to work...

#,###.###,," MM"

--
Rick (MVP - Excel)


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Custom Format .#,###,," MM"

That's dot#comma###commacomma


Gord Dibben MS Excel MVP


On Mon, 9 Mar 2009 12:12:03 -0700, Yossy
wrote:

Any Help will be appreciated. I have this 345,000 and I want to get this
formatted to this .345 MM