Hi all, I need to change the currency symbol to Pound Sterling from US Dollar...I have looked in Format Cells?

Question

I have checked the Format Cells options, but all I have the option to do is to change it to the Euro symbol. Any help is appreciated !

Answer 1

you can format cell using ctrl+1

then pick currency

then pick symbols for poundsterling

Answer 2

Pound Currency Symbol

Answer 3

Pound Sign Currency

Answer 4

Sounds like you are doing the right thing - the £ sign should be right at the top of the list in both the currency and accounting windows.



As a get by, you could manually type in the pound sign to one cell and then use format painter (the brush icon beside, Cut/Copy/Paste) to paste the format into the other cells.



Is there a dollar sign above the number 4 key? I have an american keyboard and to get a £ sign I have to Shift 3.

Answer 5

If it is just the once, you can hold down the Alt key and type 156 on the numbers pad to get the symbol. However, this will turn your number into text (I assume we are talking Excel here).



Otherwise format cells, currency, select the £ symbol (it is tucked away way down the list after all the € symbols).



If this is a permanent requirement, change your currency in regional settings in your control panel.

Answer 6

In Microsoft Windows Vista

Click the Start button, and then click Control Panel.

Click Clock, Language, and Region, and then click Change the date, time, or number format.

Note In Classic view, double-click Regional and Language Options.



On the Formats tab, select the country/region that you want to use in the list under Current format.

Answer 7

Go to Numbers Preferences and check the box for "show complete list of currencies".

Answer 8

£ - that one?



cant you copy/paste it?