Change from $ to £

  Samuel Gee 11:54 28 Oct 03
Locked

Hi,
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 03

Format, Cells, Currency, Symbol.

  Samuel Gee 12:33 28 Oct 03

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

  graham√ 12:47 28 Oct 03

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 03

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 03

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 03

The ? should have been ?

  Samuel Gee 11:24 29 Oct 03

I can't even get the pound sign now.

  graham√ 11:25 29 Oct 03

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 03

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

  VoG II 11:30 29 Oct 03

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now