Change from $ to £

  Samuel Gee 11:54 28 Oct 2003

I am using M/S Excell and the balance sheet template keeps using the $ sign when I type in £
sign.I have used the "Ask a question " portion in XL but nothing happens.It stays on £ untill I move onto a second line and then it converts the lot to $

  graham√ 12:04 28 Oct 2003

Format, Cells, Currency, Symbol.

  Samuel Gee 12:33 28 Oct 2003

Hi thanks for you swift response.Tried it,no luck
it did the exact same thing

  graham√ 12:47 28 Oct 2003

OK, Control Panel, Regional and Language, Regional Options, choose English United Kingdom. Same in Advanced. Click on Apply, OK each time.

  AndyJ 12:53 28 Oct 2003

First unprotect the sheet using Tools / Protection / Unprotect sheet, then you should be able to format the cells any way you want

  Samuel Gee 11:22 29 Oct 2003

Hi Graham and Andy,
I have tried the lot and even some boxes that came to light as the result of trying,but NO.
I enter the ? in the first column and when I enter the item in the second it clicks over to the D... $$$

  Samuel Gee 11:23 29 Oct 2003

The ? should have been ?

  Samuel Gee 11:24 29 Oct 2003

I can't even get the pound sign now.

  graham√ 11:25 29 Oct 2003

OK, you need VoG. Suggest you click this as resolved and start a new subject with 'Excel' in the title.

  graham√ 11:27 29 Oct 2003

Just seen your last post. I've not seen this before, could it be a virus?

  VoG II 11:30 29 Oct 2003

There seems to be something odd about that template. I've managed to get it to work as follows.

Unprotect the sheet.

Select all the cells where currency should be and select Format/Cells and choose Number.

Then Format/Cells and select Currency.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Why this awful City of Los Angeles job ad for a graphic designer is actually brilliant

iMac Pro review

Les meilleures prises CPL (2018)