Default settings for currency

L

Lowkey

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 $.
 
J

JudithJubilee

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
 
H

harvestman

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.
 
J

JudithJubilee

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing defauls in 2019 0
You'll need a new app to open this about link 1
Need Help with Macro Security 1
Space between currency symbol and amount 1
How do I set focus (and select text) on a text box on a modeless userform? 0
formatting currency field 2
AppleScript - How do I select a text ? 1
Word macro that can call cells out of Excel for a find and replace 0

Top