Default Currency Format

[ellistyle@gmail.com]

Hello. Thanks be to Chandoo.org. It is as helpful as Excel itself.


I am now using Excel 2010. My preference for currency formats is accounting format with no symbol, 2 decimal places with the comma separators.


Can I make that the default format when I hit the $ in the ribbon? As it stands now, I have to go into the "more accounting formats" to put the numbers in my preferred format.


Thanks,


TE

 

[Hui]

TE

3 Options

1. Setup a Custom Style, Select the More down button at the lower right of Styles and add a New Style, Setup the Number format you want and Name accordingly. The new style will be at the Upper Left corner of the Styles Tab

[code]

2. Setup a macro, as below. Save it in your personal.xlsx file and then apply it to a new button on your toolbar.

[code]

[pre][code]Sub Set_Acc_Format()
Selection.NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* ""-""??_);_(@_)"
End Sub

[/pre]
3. Change your Default Regional Settings for your computer

[/code]Goto the Control Panel, Region & Language, Additional settings and select the Currency Tab.

[/code]Setup the settings you want and apply

[/code]You will now not find the default $ button on the toolbar but a custom button.