Cannot Change the Currency Symbol to anything other then the US Dollar

[yieldhog]

I am stumped. I have a spreadsheet that allows me to format (either currency or accounting) to US Dollar. However, any attempt to change to the euro, yen, etc. results in nothing being changed. Now if I open a completely different worksheet, everything looks fine. Yet I have compared all of the options including auto correct features and there are no differences. There is no reason to believe that this is being caused by the "zoom" level as was suggested in some posts viewed elsewhere. Any ideas? Thanks.​

 

[Trevor G]

Have you found a solution? Did you look at the Normal Font Style to see what it is by default.

 

[Macropod]

Are you sure the 'values' in question aren't actually text (eg '£1.00 or ="£1.00") or being formatted via a TEXT formula (eg =TEXT(1,"£"&"0.00"))

 

[yieldhog]

Have you found a solution? Did you look at the Normal Font Style to see what it is by default.

Arial, regular font size 8

 

[yieldhog]

Yes because when I copy the worksheet to an entirely new workbook, I am able to add the currency symbol. I am wondering if it is because I have hit the limit on the number of formats available.