Re: Exchange Pounds to euros in excel spreedsheet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jason Morin (jason.morin_at_us.exel.com)
Date: 05/14/04 

Date: Fri, 14 May 2004 10:23:34 -0700

Assuming your values are in column A, you could use a
formula such as:

=A1*1.48041

and fill the formula down. Then copy the formulas and
paste special > value over the old values.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Hi
>
>I have an excel spreedsheet with more that 200 items that
>are listed in pounds and I want to convert them to euros
>at the actual exchange rate. Is it possible to do this
>without having to change them one by one?
>
>Thanks in advance for your help.
>
>Cheers
>
>Marco
>.
>

Relevant Pages

  • Exchange Pounds to euros in excel spreedsheet
    ... I have an excel spreedsheet with more that 200 items that ... are listed in pounds and I want to convert them to euros ... at the actual exchange rate. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Has Ronaldo Peaked?
    ... Cristiano could also sustain a ... RM paid 76million Euros for Zidane, and that was 7 years ago. ... as well as about 40-45 million Pounds nowadays? ...
    (rec.sport.soccer)
  • Re: Has Ronaldo Peaked?
    ... pounds at the time apparently. ... his price be negotiated in GBPs or in Euros? ... I don't profess to any special knowledge of how these things are negotiated, but surely, since United run an operation where the bulk of their revenues and expenses are bound to be measured in pounds, what matters to them in a transfer is how many pounds they get for their player - previous records in Euros don't really have a lot to do with it. ... Besides, Zidane was a world player of the year, world cup winner, Euro winner, Scudetto winner etc at the time. ...
    (rec.sport.soccer)
  • Re: Main Street Station $25/night Lost Weekend
    ... and get a discount of 35 pounds instead of 20. ... so I'll let others in our group book their ... cards give you a favorable exchange rate on foreign currency purchases. ... It worked with my Visa card. ...
    (alt.vacation.las-vegas)
  • Re: The Fed Has Wrecked the Stock Market
    ... No. but if I'd bought pounds or Euros or Aussiebucks ... Some people are talented at playing money games like the market and foreign ... but unfortunately my talents are limited to things that are completely useless. ...
    (soc.retirement)