Converting dollars into euros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Niko - 30 Jul 2007 08:10 GMT

Is it possible to convert dollars automatically into euros in Excel 2002? I
have downloaded automatically updating currency rates using MSN Money. Now I
would want to make a cell in which I could enter the amount in dollars and
see the amount in euros in the same cell. Is this possible?

Regards,
Niko

Reply to this Message

Bob Phillips - 30 Jul 2007 08:16 GMT

Just multiply the amount by the exchange rate.

SO if the amount is in A1, and the exchange rate is in C3 on Sheet2, use

=A1*Sheet2!C3

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Is it possible to convert dollars automatically into euros in Excel 2002?
> I have downloaded automatically updating currency rates using MSN Money.
[quoted text clipped - 3 lines]
> Regards,
> Niko

Reply to this Message

Niko - 30 Jul 2007 08:36 GMT

Yes, that's how I add the formula to another cell. But I would like to do
the similar thing Excel does when it, for example, converts numbers to
dates. So if I write the amount to A1 (in dollars) I would like to see it in
euros in A1, just like I can enter 1234 to A2 and see it as 18.5.1903 if the
cell is formatted as date. Is this kind of conversion possible with
currencies?

Regards,
Niko

> Just multiply the amount by the exchange rate.
>
[quoted text clipped - 9 lines]
>> Regards,
>> Niko

Reply to this Message

Bob Phillips - 30 Jul 2007 09:03 GMT

With VBA you can

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "A1:A10" '<== change to suit

On Error GoTo ws_exit
Application.EnableEvents = False

If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
.Value = .Value * Worksheets("Sheet2").Range("C3").Value
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Yes, that's how I add the formula to another cell. But I would like to do
> the similar thing Excel does when it, for example, converts numbers to
[quoted text clipped - 20 lines]
>>> Regards,
>>> Niko

Reply to this Message

Niko - 30 Jul 2007 09:20 GMT

The code does exactly what I wanted. Thank you very much!

Regards,
Niko

> With VBA you can
>
[quoted text clipped - 43 lines]
>>>> Regards,
>>>> Niko

Reply to this Message

Rick Rothstein (MVP - VB) - 30 Jul 2007 09:15 GMT

> Yes, that's how I add the formula to another cell. But I would like to do
> the similar thing Excel does when it, for example, converts numbers to
> dates. So if I write the amount to A1 (in dollars) I would like to see it
> in euros in A1, just like I can enter 1234 to A2 and see it as 18.5.1903
> if the cell is formatted as date. Is this kind of conversion possible with
> currencies?

If your dollars are in A1, put your conversion formula in A2 and format A2
for Euros by going into Format Cells, selecting Currency from the Category
list and picking X Euro (X 123) from the Symbol combo box (where the X is
going to be the Euro symbol in the display).

Rick

Reply to this Message

Rick Rothstein (MVP - VB) - 30 Jul 2007 09:23 GMT

Sorry, ignore my response... I missed the part where you said your wanted
the result in the same cell you entered the amount in.

Rick

>> Yes, that's how I add the formula to another cell. But I would like to do
>> the similar thing Excel does when it, for example, converts numbers to
[quoted text clipped - 9 lines]
>
> Rick

Reply to this Message

Rate this thread: