• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Default Currency Format

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
 
TE

3 Options

Code:
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.
 
Back
Top