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
|
|||
|
|||
Default settings for currency
Can anyone tell me how to set the default for the currency button in Excel
2003? Currently it is set to format the cell to UK pounds when I click on it and I would like to set it to $. |
#2
|
|||
|
|||
Default settings for currency
Hello Lowkey,
You may have already got the answer but here goes... Go to Format + Style. Choose Currency from the drop down, then Modify. Change the £ to $. Judith -- Hope this helps "Lowkey" wrote: Can anyone tell me how to set the default for the currency button in Excel 2003? Currently it is set to format the cell to UK pounds when I click on it and I would like to set it to $. |
#3
|
|||
|
|||
Default settings for currency
How did you change $ to £ in the first place?
This does not work within the Balance Sheet Template. The option is greyed out however I try selecting the cell. My Windows regional settings are set to UK. "JudithJubilee" wrote: Hello Lowkey, You may have already got the answer but here goes... Go to Format + Style. Choose Currency from the drop down, then Modify. Change the £ to $. Judith -- Hope this helps "Lowkey" wrote: Can anyone tell me how to set the default for the currency button in Excel 2003? Currently it is set to format the cell to UK pounds when I click on it and I would like to set it to $. |
#4
|
|||
|
|||
Default settings for currency
Hello harvestman,
The Balance Sheet Template is protected with a blank password. Choose Tools + Protection + Unprotect Sheet. This should allow you to change the $ to a £. Email back if you are still not successful. Judith -- Hope this helps "harvestman" wrote: How did you change $ to £ in the first place? This does not work within the Balance Sheet Template. The option is greyed out however I try selecting the cell. My Windows regional settings are set to UK. "JudithJubilee" wrote: Hello Lowkey, You may have already got the answer but here goes... Go to Format + Style. Choose Currency from the drop down, then Modify. Change the £ to $. Judith -- Hope this helps "Lowkey" wrote: Can anyone tell me how to set the default for the currency button in Excel 2003? Currently it is set to format the cell to UK pounds when I click on it and I would like to set it to $. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook settings, copy one user's setting to default user | Linda P | Setup, Installing & Configuration | 1 | October 11th, 2005 07:19 PM |
Can I change the default settings for the reminder of an event? | Mutley | Calendar | 2 | August 30th, 2005 05:49 PM |
[Excel] How do I change the default import external data settings. | djr | General Discussion | 1 | January 17th, 2005 10:57 PM |
Unable to Update "Default Folder settings for archiving" with .MST or .CMW | Michael Hume | General Discussion | 0 | June 10th, 2004 06:30 PM |
Unable to Update "Default Folder settings for archiving" with .MST or .CMW | Michael Hume | Setup, Installing & Configuration | 0 | June 10th, 2004 06:20 PM |