| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 $. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet Default Settings | Excel Discussion (Misc queries) | |||
| Question on default print settings | Excel Discussion (Misc queries) | |||
| change default chart settings for new excel charts automatically | Charts and Charting in Excel | |||
| Pivot Table - Default Settings for Table Options | Excel Discussion (Misc queries) | |||
| [Excel] How do I change the default import external data settings. | Excel Discussion (Misc queries) | |||
Linear Mode
