software

I have a Price column. It is in US dollar and I need it to convert Canadian
dollars.If the conversion rate is 20% Canadain to Us then US * 1.20.

So a US buck = 1.20 Can

HTH
Regards,
Howard

quot;suegrquot; gt; wrote in message
...
gt;I have a Price column. It is in US dollar and I need it to convert
gt;Canadian
gt; dollars.
gt;
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 Specialgt;Multiplygt;OKgt;Esc.

Clear the cell with 1.16.Gord Dibben Excel MVP

On Fri, 23 Dec 2005 19:45:02 -0800, quot;suegrquot; gt;
wrote:

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

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

quot;L. Howard Kittlequot; wrote:

gt; If the conversion rate is 20% Canadain to Us then US * 1.20.
gt;
gt; So a US buck = 1.20 Can
gt;
gt; HTH
gt; Regards,
gt; Howard
gt;
gt; quot;suegrquot; gt; wrote in message
gt; ...
gt; gt;I have a Price column. It is in US dollar and I need it to convert
gt; gt;Canadian
gt; gt; dollars.
gt; gt;
gt;
gt;
gt;

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

quot;Gord Dibbenquot; wrote:

gt; Current rates are 1.16 cdn to 1 us.
gt;
gt; us * 1.16 = cdn
gt;
gt; Enter 1.16 in an empty cell.
gt;
gt; Copy that.
gt;
gt; Select column with us prices and Paste Specialgt;Multiplygt;OKgt;Esc.
gt;
gt; Clear the cell with 1.16.
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Fri, 23 Dec 2005 19:45:02 -0800, quot;suegrquot; gt;
gt; wrote:
gt;
gt; gt;I have a Price column. It is in US dollar and I need it to convert Canadian
gt; gt;dollars.
gt;

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 B1Gord

On Fri, 23 Dec 2005 21:08:02 -0800, quot;suegrquot; gt;
wrote:

gt;I am so sorry. I know the conversion is my price * 1.20. I just can't get
gt;the formula to multiply the entire column. If it is in the D column I
gt;thought I could just do D = D * 1.2 but this does not work. This new excel
gt;is not what I was used to.
gt;Thanks in advance! Sorry it is such a basic question. Susan
gt;
gt;quot;L. Howard Kittlequot; wrote:
gt;
gt;gt; If the conversion rate is 20% Canadain to Us then US * 1.20.
gt;gt;
gt;gt; So a US buck = 1.20 Can
gt;gt;
gt;gt; HTH
gt;gt; Regards,
gt;gt; Howard
gt;gt;
gt;gt; quot;suegrquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a Price column. It is in US dollar and I need it to convert
gt;gt; gt;Canadian
gt;gt; gt; dollars.
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;

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

quot;Gord Dibbenquot; wrote:

gt; Enter this formula in B1 assuming your us prices are in column A.
gt;
gt; =A1*1.16
gt;
gt; Copy that down column B by dragging on the fill handle of B1
gt;
gt;
gt; Gord
gt;
gt; On Fri, 23 Dec 2005 21:08:02 -0800, quot;suegrquot; gt;
gt; wrote:
gt;
gt; gt;I am so sorry. I know the conversion is my price * 1.20. I just can't get
gt; gt;the formula to multiply the entire column. If it is in the D column I
gt; gt;thought I could just do D = D * 1.2 but this does not work. This new excel
gt; gt;is not what I was used to.
gt; gt;Thanks in advance! Sorry it is such a basic question. Susan
gt; gt;
gt; gt;quot;L. Howard Kittlequot; wrote:
gt; gt;
gt; gt;gt; If the conversion rate is 20% Canadain to Us then US * 1.20.
gt; gt;gt;
gt; gt;gt; So a US buck = 1.20 Can
gt; gt;gt;
gt; gt;gt; HTH
gt; gt;gt; Regards,
gt; gt;gt; Howard
gt; gt;gt;
gt; gt;gt; quot;suegrquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have a Price column. It is in US dollar and I need it to convert
gt; gt;gt; gt;Canadian
gt; gt;gt; gt; dollars.
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;

Select Column B and Editgt;Copy.

In place, Editgt;Paste Specialgt;Valuesgt;OKgt;Esc.

Delete Column A.Gord

On Sat, 24 Dec 2005 12:48:01 -0800, quot;suegrquot; gt;
wrote:

gt;This worked! However I need to get rid of column A. In other words I can
gt;only list one column, only Canadian pricing, need to get rid of column a. I
gt;tried saving as text but there are over 7,000 records and do not want to do
gt;by hand!
gt;Thanks! Susan
gt;
gt;quot;Gord Dibbenquot; wrote:
gt;
gt;gt; Enter this formula in B1 assuming your us prices are in column A.
gt;gt;
gt;gt; =A1*1.16
gt;gt;
gt;gt; Copy that down column B by dragging on the fill handle of B1
gt;gt;
gt;gt;
gt;gt; Gord
gt;gt;
gt;gt; On Fri, 23 Dec 2005 21:08:02 -0800, quot;suegrquot; gt;
gt;gt; wrote:
gt;gt;
gt;gt; gt;I am so sorry. I know the conversion is my price * 1.20. I just can't get
gt;gt; gt;the formula to multiply the entire column. If it is in the D column I
gt;gt; gt;thought I could just do D = D * 1.2 but this does not work. This new excel
gt;gt; gt;is not what I was used to.
gt;gt; gt;Thanks in advance! Sorry it is such a basic question. Susan
gt;gt; gt;
gt;gt; gt;quot;L. Howard Kittlequot; wrote:
gt;gt; gt;
gt;gt; gt;gt; If the conversion rate is 20% Canadain to Us then US * 1.20.
gt;gt; gt;gt;
gt;gt; gt;gt; So a US buck = 1.20 Can
gt;gt; gt;gt;
gt;gt; gt;gt; HTH
gt;gt; gt;gt; Regards,
gt;gt; gt;gt; Howard
gt;gt; gt;gt;
gt;gt; gt;gt; quot;suegrquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I have a Price column. It is in US dollar and I need it to convert
gt;gt; gt;gt; gt;Canadian
gt;gt; gt;gt; gt; dollars.
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;

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

quot;Gord Dibbenquot; wrote:

gt; Select Column B and Editgt;Copy.
gt;
gt; In place, Editgt;Paste Specialgt;Valuesgt;OKgt;Esc.
gt;
gt; Delete Column A.
gt;
gt;
gt; Gord
gt;
gt; On Sat, 24 Dec 2005 12:48:01 -0800, quot;suegrquot; gt;
gt; wrote:
gt;
gt; gt;This worked! However I need to get rid of column A. In other words I can
gt; gt;only list one column, only Canadian pricing, need to get rid of column a. I
gt; gt;tried saving as text but there are over 7,000 records and do not want to do
gt; gt;by hand!
gt; gt;Thanks! Susan
gt; gt;
gt; gt;quot;Gord Dibbenquot; wrote:
gt; gt;
gt; gt;gt; Enter this formula in B1 assuming your us prices are in column A.
gt; gt;gt;
gt; gt;gt; =A1*1.16
gt; gt;gt;
gt; gt;gt; Copy that down column B by dragging on the fill handle of B1
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; Gord
gt; gt;gt;
gt; gt;gt; On Fri, 23 Dec 2005 21:08:02 -0800, quot;suegrquot; gt;
gt; gt;gt; wrote:
gt; gt;gt;
gt; gt;gt; gt;I am so sorry. I know the conversion is my price * 1.20. I just can't get
gt; gt;gt; gt;the formula to multiply the entire column. If it is in the D column I
gt; gt;gt; gt;thought I could just do D = D * 1.2 but this does not work. This new excel
gt; gt;gt; gt;is not what I was used to.
gt; gt;gt; gt;Thanks in advance! Sorry it is such a basic question. Susan
gt; gt;gt; gt;
gt; gt;gt; gt;quot;L. Howard Kittlequot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; If the conversion rate is 20% Canadain to Us then US * 1.20.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; So a US buck = 1.20 Can
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; HTH
gt; gt;gt; gt;gt; Regards,
gt; gt;gt; gt;gt; Howard
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;suegrquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt;I have a Price column. It is in US dollar and I need it to convert
gt; gt;gt; gt;gt; gt;Canadian
gt; gt;gt; gt;gt; gt; dollars.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt;

Keep at it Susan

It does get easierlt;ggt;Gord

On Sat, 24 Dec 2005 18:57:01 -0800, quot;suegrquot; gt;
wrote:

gt;Thank you so much! Works perfectly. I feel silly not knowing the program.
gt;I used to be fluent years ago and it just left me. I am sincerely
gt;appreciative of your assistance. Kind regards, Susan
gt;
gt;quot;Gord Dibbenquot; wrote:
gt;
gt;gt; Select Column B and Editgt;Copy.
gt;gt;
gt;gt; In place, Editgt;Paste Specialgt;Valuesgt;OKgt;Esc.
gt;gt;
gt;gt; Delete Column A.
gt;gt;
gt;gt;
gt;gt; Gord
gt;gt;
gt;gt; On Sat, 24 Dec 2005 12:48:01 -0800, quot;suegrquot; gt;
gt;gt; wrote:
gt;gt;
gt;gt; gt;This worked! However I need to get rid of column A. In other words I can
gt;gt; gt;only list one column, only Canadian pricing, need to get rid of column a. I
gt;gt; gt;tried saving as text but there are over 7,000 records and do not want to do
gt;gt; gt;by hand!
gt;gt; gt;Thanks! Susan
gt;gt; gt;
gt;gt; gt;quot;Gord Dibbenquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Enter this formula in B1 assuming your us prices are in column A.
gt;gt; gt;gt;
gt;gt; gt;gt; =A1*1.16
gt;gt; gt;gt;
gt;gt; gt;gt; Copy that down column B by dragging on the fill handle of B1
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; Gord
gt;gt; gt;gt;
gt;gt; gt;gt; On Fri, 23 Dec 2005 21:08:02 -0800, quot;suegrquot; gt;
gt;gt; gt;gt; wrote:
gt;gt; gt;gt;
gt;gt; gt;gt; gt;I am so sorry. I know the conversion is my price * 1.20. I just can't get
gt;gt; gt;gt; gt;the formula to multiply the entire column. If it is in the D column I
gt;gt; gt;gt; gt;thought I could just do D = D * 1.2 but this does not work. This new excel
gt;gt; gt;gt; gt;is not what I was used to.
gt;gt; gt;gt; gt;Thanks in advance! Sorry it is such a basic question. Susan
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;quot;L. Howard Kittlequot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; If the conversion rate is 20% Canadain to Us then US * 1.20.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; So a US buck = 1.20 Can
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; HTH
gt;gt; gt;gt; gt;gt; Regards,
gt;gt; gt;gt; gt;gt; Howard
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; quot;suegrquot; gt; wrote in message
gt;gt; gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;gt; gt;I have a Price column. It is in US dollar and I need it to convert
gt;gt; gt;gt; gt;gt; gt;Canadian
gt;gt; gt;gt; gt;gt; gt; dollars.
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;