cell * figure
 

I have a Price column. It is in US dollar and I need it to convert Canadian
dollars.

cell * figure
 

If the conversion rate is 20% Canadain to Us then US * 1.20.

So a US buck = 1.20 Can

HTH
Regards,
Howard

"suegr" wrote in message
...
I have a Price column. It is in US dollar and I need it to convert
Canadian
dollars.

cell * figure
 

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 SpecialMultiplyOKEsc.

Clear the cell with 1.16.


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 19:45:02 -0800, "suegr"
wrote:

I have a Price column. It is in US dollar and I need it to convert Canadian
dollars.

cell * figure
 

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

"L. Howard Kittle" wrote:

If the conversion rate is 20% Canadain to Us then US * 1.20.

So a US buck = 1.20 Can

HTH
Regards,
Howard

"suegr" wrote in message
...
I have a Price column. It is in US dollar and I need it to convert
Canadian
dollars.

cell * figure
 

When I select paste special it just shows Unicode text or regular text.....
It makes sense but doesn't work with this office 2000...

"Gord Dibben" wrote:

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 SpecialMultiplyOKEsc.

Clear the cell with 1.16.


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 19:45:02 -0800, "suegr"
wrote:

I have a Price column. It is in US dollar and I need it to convert Canadian
dollars.

cell * figure
 

Enter this formula in B1 assuming your us prices are in column A.

=A1*1.16

Copy that down column B by dragging on the fill handle of B1


Gord

On Fri, 23 Dec 2005 21:08:02 -0800, "suegr"
wrote:

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

"L. Howard Kittle" wrote:

If the conversion rate is 20% Canadain to Us then US * 1.20.

So a US buck = 1.20 Can

HTH
Regards,
Howard

"suegr" wrote in message
...
I have a Price column. It is in US dollar and I need it to convert
Canadian
dollars.

cell * figure
 

This worked! However I need to get rid of column A. In other words I can
only list one column, only Canadian pricing, need to get rid of column a. I
tried saving as text but there are over 7,000 records and do not want to do
by hand!
Thanks! Susan

"Gord Dibben" wrote:

Enter this formula in B1 assuming your us prices are in column A.

=A1*1.16

Copy that down column B by dragging on the fill handle of B1


Gord

On Fri, 23 Dec 2005 21:08:02 -0800, "suegr"
wrote:

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

"L. Howard Kittle" wrote:

If the conversion rate is 20% Canadain to Us then US * 1.20.

So a US buck = 1.20 Can

HTH
Regards,
Howard

"suegr" wrote in message
...
I have a Price column. It is in US dollar and I need it to convert
Canadian
dollars.

cell * figure
 

Select Column B and EditCopy.

In place, EditPaste SpecialValuesOKEsc.

Delete Column A.


Gord

On Sat, 24 Dec 2005 12:48:01 -0800, "suegr"
wrote:

This worked! However I need to get rid of column A. In other words I can
only list one column, only Canadian pricing, need to get rid of column a. I
tried saving as text but there are over 7,000 records and do not want to do
by hand!
Thanks! Susan

"Gord Dibben" wrote:

Enter this formula in B1 assuming your us prices are in column A.

=A1*1.16

Copy that down column B by dragging on the fill handle of B1


Gord

On Fri, 23 Dec 2005 21:08:02 -0800, "suegr"
wrote:

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

"L. Howard Kittle" wrote:

If the conversion rate is 20% Canadain to Us then US * 1.20.

So a US buck = 1.20 Can

HTH
Regards,
Howard

"suegr" wrote in message
...
I have a Price column. It is in US dollar and I need it to convert
Canadian
dollars.

cell * figure
 

Thank you so much! Works perfectly. I feel silly not knowing the program.
I used to be fluent years ago and it just left me. I am sincerely
appreciative of your assistance. Kind regards, Susan

"Gord Dibben" wrote:

Select Column B and EditCopy.

In place, EditPaste SpecialValuesOKEsc.

Delete Column A.


Gord

On Sat, 24 Dec 2005 12:48:01 -0800, "suegr"
wrote:

This worked! However I need to get rid of column A. In other words I can
only list one column, only Canadian pricing, need to get rid of column a. I
tried saving as text but there are over 7,000 records and do not want to do
by hand!
Thanks! Susan

"Gord Dibben" wrote:

Enter this formula in B1 assuming your us prices are in column A.

=A1*1.16

Copy that down column B by dragging on the fill handle of B1


Gord

On Fri, 23 Dec 2005 21:08:02 -0800, "suegr"
wrote:

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

"L. Howard Kittle" wrote:

If the conversion rate is 20% Canadain to Us then US * 1.20.

So a US buck = 1.20 Can

HTH
Regards,
Howard

"suegr" wrote in message
...
I have a Price column. It is in US dollar and I need it to convert
Canadian
dollars.

cell * figure
 

Keep at it Susan

It does get easier<g


Gord

On Sat, 24 Dec 2005 18:57:01 -0800, "suegr"
wrote:

Thank you so much! Works perfectly. I feel silly not knowing the program.
I used to be fluent years ago and it just left me. I am sincerely
appreciative of your assistance. Kind regards, Susan

"Gord Dibben" wrote:

Select Column B and EditCopy.

In place, EditPaste SpecialValuesOKEsc.

Delete Column A.


Gord

On Sat, 24 Dec 2005 12:48:01 -0800, "suegr"
wrote:

This worked! However I need to get rid of column A. In other words I can
only list one column, only Canadian pricing, need to get rid of column a. I
tried saving as text but there are over 7,000 records and do not want to do
by hand!
Thanks! Susan

"Gord Dibben" wrote:

Enter this formula in B1 assuming your us prices are in column A.

=A1*1.16

Copy that down column B by dragging on the fill handle of B1


Gord

On Fri, 23 Dec 2005 21:08:02 -0800, "suegr"
wrote:

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

"L. Howard Kittle" wrote:

If the conversion rate is 20% Canadain to Us then US * 1.20.

So a US buck = 1.20 Can

HTH
Regards,
Howard

"suegr" wrote in message
...
I have a Price column. It is in US dollar and I need it to convert
Canadian
dollars.