Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Pounfs to US Dollars
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Pounfs to US Dollars
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? :-( -- David Biddulph "Tom" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Pounfs to US Dollars
--Type 1.6767 in a unused cell.and copy the cell
--Keeping the copy select the cells with amount. --Right clickPasteSpecialDivide OK If this post helps click Yes --------------- Jacob Skaria "Tom" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Pounfs to US Dollars
You may also want to download the currency convertor template, as this will maintain current conversion rates. http://office.microsoft.com/en-us/te...CT101444811033 "Tom" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Live Currency Conversion US Dollars to Australian Dollars | Excel Discussion (Misc queries) | |||
Converting from Norwegian Krone to US Dollars format | Excel Worksheet Functions | |||
Converting currency from US Dollar into Canadian dollars from column A to Column B | Excel Worksheet Functions | |||
converting time worked to dollars earned. | New Users to Excel | |||
converting #dollars into word dollars? | Excel Worksheet Functions |