Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Change the default Currency style
It is both frustrating an nonsenical that the default Currency style (ie the
one applied when you click the Currency button on the Formatting toolbar) is actually based on an Accounting format. Why isn't it based on a Currency format? .... and why can't it be changed without creating a template? (ie so it applies to all Workbooks rather than just newly created ones) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Change the default Currency style
BudgieBoy
You probably could find as many people who want it the other way. You could take two routes. 1) In existing workbooks - To change all 'currency' formatted cells in one go. Go to FormatStylesCurrencyModify... change it to Currency and ok out of dialogs. This will reset the 'currency style for this workbook and all cells formatted as 'currency' will be changed immediately and future button presses will format this way for this book 2) Re-purpose your currency button by inserting the below code in personal.xls Sub NewCurrencyFormat() Selection.NumberFormat = "£#,##0.00;-£#,##0.00" End Sub and then right click on any toolbar, select 'customize'. With the dialog showing, right-click on the currency button and select 'assign macro...' and select this code. This will re-purpose the button for all future applications of 'currency' You could also have a button which sets the currency for existing sheets (as 1) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Budgie Boy" <Budgie wrote in message ... It is both frustrating an nonsenical that the default Currency style (ie the one applied when you click the Currency button on the Formatting toolbar) is actually based on an Accounting format. Why isn't it based on a Currency format? ... and why can't it be changed without creating a template? (ie so it applies to all Workbooks rather than just newly created ones) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency Style Button | Excel Discussion (Misc queries) | |||
How do I change the Font Default for Comment in Excel 2000? | Excel Discussion (Misc queries) | |||
Change default measurements from cm to inches | Setting up and Configuration of Excel | |||
im trying to change the default currency for my excel from $ to M. | Excel Discussion (Misc queries) | |||
How can I change the default 'comma' format. Eg paranthesis inste. | Excel Discussion (Misc queries) |