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 |
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 |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com