Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel $ to problem


  • Please log in to reply
3 replies to this topic

#1 scubatony

scubatony

  • Members
  • 23 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:05:36 PM

Posted 08 June 2011 - 04:09 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

Edited by hamluis, 08 June 2011 - 11:10 AM.
Moved from External Hardware to Business Apps.


BC AdBot (Login to Remove)

 


#2 Eyesee

Eyesee

    Bleepin Teck Shop


  • BC Advisor
  • 3,541 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:In the middle of Kansas
  • Local time:11:36 AM

Posted 08 June 2011 - 12:13 PM

You can store the current exchange rate somewhere in the spreadsheet.
Then multiply dollars by the exchange rate.
In the beginning there was the command line.

#3 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,574 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:12:36 PM

Posted 08 June 2011 - 04:16 PM

If conversion and recalculation isn't what you're looking for, normally Excel picks up regional settings from the system. It should be your default, I would think, if you're in Europe. Regardless, search HELP for Euro or currency. I see this in the off-line HELP for my Excel2003:

Format values in euro currency style
Some of the content in this topic may not be applicable to some languages.

This process does not convert cell values.

Select the cells that you want to format as euro currency style.
Click Euro on the Formatting toolbar. If Euro is not available, you must load the Euro Currency Tools add-in program.
How?

On the Tools menu, click Add-Ins.
If the add-in you want to use is not listed in the Add-Ins available box, click Browse, and then locate the add-in.

In the Add-Ins available box, select the check box next to the add-in you want to load, and then click OK.
If necessary, follow the instructions in the setup program.
Note The regional settings for currency in Microsoft Windows Control Panel determine the position of the euro sign (that is, whether the symbol appears before or after the number and whether a space separates the symbol and the number). To change this positioning, create a Custom currency style. The regional settings for currency in Control Panel also determine the decimal symbol and the thousands separator.



#4 scubatony

scubatony
  • Topic Starter

  • Members
  • 23 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:05:36 PM

Posted 09 June 2011 - 02:07 AM

Thanks guys problem now sorted :busy:




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users