If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office 2003 Standard MultiLingual User Interface (MUI) installation | [email protected] | Setup, Installing & Configuration | 3 | May 23rd, 2006 11:59 AM |
How do I change the default calendar print style from monthly to . | lglaser | Calendar | 0 | December 3rd, 2004 09:27 PM |
Can a style become font-neutral? | F A L | Page Layout | 5 | December 3rd, 2004 01:12 PM |
Problems with Style formatting | terrapinie | Formatting Long Documents | 2 | July 7th, 2004 06:18 PM |
modify heading 2 style in Word xp | sam | New Users | 6 | June 9th, 2004 12:03 AM |