Convert number to Million Currency format
 

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

Answer: Convert number to Million Currency format
 

Sure, I can help you with that! Here's how you can convert the number 345,000 to the million currency format of .345 MM in Microsoft Excel:

1. Select the cell containing the number you want to convert to million currency format.
2. Right-click on the cell and select "Format Cells" from the drop-down menu.
3. In the "Format Cells" dialog box, select the "Custom" category.
4. In the "Type" field, enter the following format code:
   Code:

   ---

   0.000,," MM"

   ---

5. Click "OK" to apply the format to the cell.
6. The number 345,000 should now be displayed as .345 MM in the cell.

That's it! You have successfully converted the number to million currency format. If you have any other questions or need further assistance, feel free to ask.

Convert number to Million Currency format
 

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

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

Convert number to Million Currency format
 

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"

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"

Convert number to Million Currency format
 

SP3


Gord

On Mon, 9 Mar 2009 17:36:08 -0400, "Rick Rothstein"
wrote:

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

Convert number to Million Currency format
 

I don't get it... I cannot make your suggest format pattern work on my
system... it keeps throwing away the comma leaving four # characters after
the decimal point.

--
Rick (MVP - Excel)


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
SP3


Gord

On Mon, 9 Mar 2009 17:36:08 -0400, "Rick Rothstein"
wrote:

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

Convert number to Million Currency format
 

I now see what you mean.

Enter in Custom .#,###,," MM" and OK

Excel changes to .####,," MM"

I just noticed that.

I never paid attention to what Excel did after I got the display in the
Sample dialog and hit OK

But the resultant display is .345 MM as OP wanted.

Sorry about not picking up the "missing comma" earlier.


Gord

On Mon, 9 Mar 2009 19:20:38 -0400, "Rick Rothstein"
wrote:

I don't get it... I cannot make your suggest format pattern work on my
system... it keeps throwing away the comma leaving four # characters after
the decimal point.

Convert number to Million Currency format
 

Phew! I'm thought I was going crazy there for a moment.<g

Yes, you get the display the OP wanted... for that number. The original
intention of your format pattern was to round to 3 decimal places maximum
and to include the thousands separator... after Excel changes the pattern,
numbers will be rounded to 4 decimal places maximum and there will be no
thousands separator in numbers large enough to warrant them.

--
Rick (MVP - Excel)


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I now see what you mean.

Enter in Custom .#,###,," MM" and OK

Excel changes to .####,," MM"

I just noticed that.

I never paid attention to what Excel did after I got the display in the
Sample dialog and hit OK

But the resultant display is .345 MM as OP wanted.

Sorry about not picking up the "missing comma" earlier.


Gord

On Mon, 9 Mar 2009 19:20:38 -0400, "Rick Rothstein"
wrote:

I don't get it... I cannot make your suggest format pattern work on my
system... it keeps throwing away the comma leaving four # characters after
the decimal point.