View Single Post
  #6   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

Hmm! I wonder what the difference is? What SP are you at?

--
Rick (MVP - Excel)


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
My Excel version 2003 returns .345 MM with Custom Format I posted.

I tested before posting.

Yours returns same thing .345 MM



Gord




On Mon, 9 Mar 2009 16:33:50 -0400, "Rick Rothstein"
wrote:

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"