Change from $ to £

  [DELETED] 11:54 28 Oct 2003
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 2003

Format, Cells, Currency, Symbol.

  [DELETED] 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.

  [DELETED] 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

  [DELETED] 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... $$$

  [DELETED] 11:23 29 Oct 2003

The ? should have been ?

  [DELETED] 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?

  [DELETED] 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

Microsoft Surface Book 2 15in review

How to create explosive dance music graphics

When is the best time to buy an iPhone?

Quel antivirus gratuit choisir pour un PC ?