S
suegr
I have a Price column. It is in US dollar and I need it to convert Canadian
dollars.
dollars.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
L. Howard Kittle
If the conversion rate is 20% Canadain to Us then US * 1.20.
So a US buck = 1.20 Can
HTH
Regards,
Howard
So a US buck = 1.20 Can
HTH
Regards,
Howard
G
Gord Dibben
Current rates are 1.16 cdn to 1 us.
us * 1.16 = cdn
Enter 1.16 in an empty cell.
Copy that.
Select column with us prices and Paste Special>Multiply>OK>Esc.
Clear the cell with 1.16.
Gord Dibben Excel MVP
us * 1.16 = cdn
Enter 1.16 in an empty cell.
Copy that.
Select column with us prices and Paste Special>Multiply>OK>Esc.
Clear the cell with 1.16.
Gord Dibben Excel MVP
S
suegr
I am so sorry. I know the conversion is my price * 1.20. I just can't get
the formula to multiply the entire column. If it is in the D column I
thought I could just do D = D * 1.2 but this does not work. This new excel
is not what I was used to.
Thanks in advance! Sorry it is such a basic question. Susan
the formula to multiply the entire column. If it is in the D column I
thought I could just do D = D * 1.2 but this does not work. This new excel
is not what I was used to.
Thanks in advance! Sorry it is such a basic question. Susan
S
suegr
When I select paste special it just shows Unicode text or regular text.....
It makes sense but doesn't work with this office 2000...
It makes sense but doesn't work with this office 2000...