Convert $ to £ in Excel

  scubatony55 08 Jun 11
Locked

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

  scubatony55 08 Jun 11

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.

  wiz-king 09 Jun 11

That will change the displayed displayed currency but it wont change the contents of the cell.

  Terry Brown 25 Jun 11

Open EXCEL in the help box (right side) type in 'convert currency'. Follow instruction to load add in.

Apply to the sheet as necessary.

Terry

Advertisement

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

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

IKinema aims to banish droopy shoulders and wonky spines in animated CG characters

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message