# [SOLVED] How do I set up currency conversion in Excel?

1. ## [SOLVED] How do I set up currency conversion in Excel?

Living in UK, for some reason I appear to have only the Euro currency
convertor on Excel 2002. I need to convert Â£GBP costs into \$USD. I cannot
find a download. Does any body know of a 'quick-fix' or of a macro that will
Thanking you in anticipation.

2. ## RE: How do I set up currency conversion in Excel?

There are 2 options I can think of.

1) Create a formula that does the conversion. example Â£ to USD
=A1*A2 where A1 contains Â£ and A2 contains the converstion rate
say 0.60
=.6 Â£1 coverts to 0.6USD

2) Enter this code into a new module, select the range and then run the macro.
Assuming the conversion rate is in cell A1

Sub Converter()

Dim Rng As Range

For Each Rng In Selection.Cells
Rng.Formula = Rng * Range("D58")
Next Rng

End Sub

Hope that helps

___________________
Naz
Lodon

"AMT1957" wrote:

> Living in UK, for some reason I appear to have only the Euro currency
> convertor on Excel 2002. I need to convert Â£GBP costs into \$USD. I cannot
> find a download. Does any body know of a 'quick-fix' or of a macro that will
> Thanking you in anticipation.

3. ## RE: How do I set up currency conversion in Excel?

Sorry the code should read as follows, the change was Range("D58") changed to
Range ("A1").
The cell in between the quotes is basically where the conversion rate
resides, so can be anything you want.

Sub Converter()

Dim Rng As Range

For Each Rng In Selection.Cells
Rng.Formula = Rng * Range("A1")
Next Rng

End Sub

"AMT1957" wrote:

> Living in UK, for some reason I appear to have only the Euro currency
> convertor on Excel 2002. I need to convert Â£GBP costs into \$USD. I cannot
> find a download. Does any body know of a 'quick-fix' or of a macro that will
> Thanking you in anticipation.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1