Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Convert $ to in an Excel spreadsheet  (Read 1409 times)

0 Members and 1 Guest are viewing this topic.

scubatony

    Topic Starter


    Rookie

    • Yes
  • Certifications: List
  • Experience: Experienced
  • OS: Windows 7
Convert $ to in an Excel spreadsheet
« on: June 08, 2011, 03:23:29 AM »
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.

scubatony

    Topic Starter


    Rookie

    • Yes
  • Certifications: List
  • Experience: Experienced
  • OS: Windows 7
Re: Convert $ to in an Excel spreadsheet
« Reply #1 on: June 08, 2011, 04:05:05 AM »
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.

Geek-9pm


    Mastermind
  • Geek After Dark
  • Thanked: 1001
    • Gekk9pm bnlog
  • Certifications: List
  • Computer: Specs
  • Experience: Expert
  • OS: Windows XP
Re: Convert $ to in an Excel spreadsheet
« Reply #2 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.

patio

  • Moderator


  • Genius
  • Maud' Dib
  • Thanked: 1708
    • Yes
  • Experience: Beginner
  • OS: Windows 7
Re: Convert $ to in an Excel spreadsheet
« Reply #3 on: June 08, 2011, 07:10:43 PM »
Actually it changes daily...
   
 
" Anyone who goes to a psychiatrist should have his head examined. "

scubatony

    Topic Starter


    Rookie

    • Yes
  • Certifications: List
  • Experience: Experienced
  • OS: Windows 7
Re: Convert $ to in an Excel spreadsheet
« Reply #4 on: June 09, 2011, 01:16:18 AM »
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

Please read my thread  >:(

This is NOT what I asked for  ???