Excel - Conversion for Foreign Exchange

[jwcorn]

I work for an international company and am constantly faced wit
spreadsheets of financial data supplied in one currency that must b
totally converted to another.

Duplicating the spreadsheet and building a formula in each cell tha
refers to a "seed" cell with the conversion rate is extremely tim
consuming, and must be duplicated each time a new original sheet i
received.

As far as I know, the Euro conversion function only works for th
companies actually involved in the Euro community, and can't be use
for dollars to Euros, or Pesos to Pounds.

Conceptually, I'm looking for a way to multiply every cell with number
in it by a conversion rate, without wiping out the formating an
totalling formulas as they exist in the original.

Is there an easier way

 

[Frank Kabel]

Hi
you may try:
- insert the conversion factor in a single cell
- copy this cell
- select your data
- goto 'Edit - Paste Special' and choose 'Multiply'

The reason Excel's conversion factors work only for the EU currencies
is that there's (there was) a fixed conversion factor for each
currency

 

[jeff]

Hi,
I like Frank's idea best, but you could use a
macro to factor.

Sub ConvertCurrency()
Dim x As Double
Dim y As String
Dim r As Range
Set r = Range("A2:A10")
y = InputBox("Enter Factor (xxx.xxxx) ", "Factor")
If y = "" Then Exit Sub
Range("A1") = y
x = Val(y)
For Each c In r
'the next lines stores value in cell to right
c.Offset(0, 1).Value = c * x
'or use this to replace with new value
'c.Value = c * x
Next c
End Sub

jeff