12.25 to display as $12,250,000 using custom formatting

**arsenal123gunners** · 06-24-2010, 09:34 PM

Is there anyway to have a custom format to multiply a number by 1 million? Like if I type in 4.252 it shows up as $4,252,000 etc.

**shg** · 06-24-2010, 10:12 PM

No, you can't do that with a format. You can only go the other way.

**zbor** · 06-25-2010, 03:04 AM

You can format cells as: [$$-409]#.##0,000 000

(maybe you'll need to switch , and . )

**martindwilson** · 06-25-2010, 03:20 AM

zbor that
[$$-409] bit what does it do ? as far as i'm aware that causes problems in 2007 with default format of workbook. and best thing is to delete any custom formats starting with that.

**zbor** · 06-25-2010, 03:21 AM

I have no idea.. I've just copy from custom format box since it was working for me

**Marcol** · 06-25-2010, 04:15 AM

A simple VBa solution might be

1/. Format column A > Accounting > symbol > $

2/. Put this code in the Sheet Module for the Sheet you need to "Format"

Please Login or Register  to view this content.

Numbers entered in Column A will be a real value, not just a formatted display value.

To enter the code in the correct sheet module.

Right click on the sheet tab you require then click > view code
Paste all of the code in the resultant pane, (this is the Worksheet Module)

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.