Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell * figure
I have a Price column. It is in US dollar and I need it to convert Canadian
dollars. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
Percentage difference calc that knows the largest figure | Excel Discussion (Misc queries) | |||
change the colour of text in cell for minus figure | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |