Hi There People

I have downloaded an Excel spreadsheet but the monetary values are in $ I NEED to change then to £.

Can anybody help please

I am using XP and it concerns OFFICE 2010

Regards

Tony
P.S Mods sorry if this is in the wrong section,please feel free to move it to the right one.This just in

Hello scubatony:

Your question on Microsoft Answers has received a reply:
Question
Convert $ to £ in Excel
Reply
Highlight the range of cells you want to change.
Right CLICK and click on:-
Format Cells . . .
The Format Cells window should open.
Click on the Number tab.
In the:-
Category:
 - box SET it to:-
Currency
then click on the pound symbol (in the Symbol: box).
Click OK.
If my comments have helped please vote as helpful.
Thanks.
Some additional information is needed.
What does this spreadsheet do? Is it a list of prices of a line of products for sale? Is this spreadsheet a static thing, it is not going to be updated?

1 US dollar = 0.6101 British pounds sterling

The price maybe drooping slowly. Or maybe not.Actually it changes daily... Quote from: Geek-9pm on June 08, 2011, 05:47:42 PM

Some additional information is needed.
What does this spreadsheet do? Is it a list of prices of a line of products for sale? Is this spreadsheet a static thing, it is not going to be updated?

1 US dollar = 0.6101 British pounds sterling
The price maybe drooping slowly. Or maybe not