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"
|