Excel currency symbol

When I click on the currency format button in Excel, it formats the selected cells using a dollar symbol.

Problem is, I'm in the UK. I'd like it to use the £ symbol.

My Windows regional settings are correct. If I go to the Format / Cells / Currency dialog in Excel, the first symbol in the list is the correct £ symbol.

Same PC, wife's user account, Excel does the right thing.

Ideas?

My google-fu is weak this evening. Although I did find an excerpt from a MS press book that claims that we use the dot as a thousands separator in the UK (we don't).

Which version of Excel? We had similar problems when we upgraded from 97 to 2k, in the end we ended up setting locales in logon scripts (although there has to be a better way).

Is it possible that you're editing an existing spreadsheet that already had $ defined as its default currency symbol?

Quote:
Is it possible that you're editing an existing spreadsheet that already had $ defined as its default currency symbol?

Bingo.

I created the spreadsheet using the Right-click / New -> Excel spreadsheet menu option, which creates the file from a template (in C:\Documents and Settings\roger\Templates).

If I create a new sheet using File -> New from within Excel, it works fine.