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
|