Converting Pounfs to US Dollars

[Tom]

Assistance please. I have a spreadsheet (P&L) in pounds. How can I most
easilly convert to US dollars without destroyind formulas etc.?

Conversion rate os $1 = 1.6767 pounds

 

[David Biddulph]

Put 1.6767 in a spare cell and copy, then Edit/ Goto/ Special/ Constants to
select the right range of values (and not your formulae), and Edit/ Paste
special/ Divide (or Multiply, see below).

Are you sure that it's $1 = 1.6767 pounds and not the other way round? Or
has the pound had a VERY bad day on the exchanges? :-(

 

[Jacob Skaria]

--Type 1.6767 in a unused cell.and copy the cell
--Keeping the copy select the cells with amount.
--Right click>PasteSpecial>Divide> OK


If this post helps click Yes

 

[Sean Timmons]

You may also want to download the currency convertor template, as this will
maintain current conversion rates.

http://office.microsoft.com/en-us/templates/TC010175541033.aspx?pid=CT101444811033