Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I divide or multiply an entire column?
I have a price list that I need to convert entire columns by either dividing
them or multipication. Is there a formula to do this. |
#2
|
|||
|
|||
Enter your multiplier in an unused cell, NOT in the column you're going to
multiply, then right-click on it and do Copy, then highlight the cells to be multiplied and do .PasteSpecial, and check the Multiply box, then OK Vaya con Dios, Chuck, CABGx3 "1number" wrote in message ... I have a price list that I need to convert entire columns by either dividing them or multipication. Is there a formula to do this. |
#3
|
|||
|
|||
When I do the .Paste Special all I see is Text and Unicode Text. Also when I
try to highlight the cells it changes them all to the same number. "CLR" wrote: Enter your multiplier in an unused cell, NOT in the column you're going to multiply, then right-click on it and do Copy, then highlight the cells to be multiplied and do .PasteSpecial, and check the Multiply box, then OK Vaya con Dios, Chuck, CABGx3 "1number" wrote in message ... I have a price list that I need to convert entire columns by either dividing them or multipication. Is there a formula to do this. |
#4
|
|||
|
|||
How did you copy that cell?
Did you copy the contents from the formula bar or did you select the cell then Edit|copy? If you didn't use Edit|Copy (or rightclick copy or ctrl-c), then try it that way. 1number wrote: When I do the .Paste Special all I see is Text and Unicode Text. Also when I try to highlight the cells it changes them all to the same number. "CLR" wrote: Enter your multiplier in an unused cell, NOT in the column you're going to multiply, then right-click on it and do Copy, then highlight the cells to be multiplied and do .PasteSpecial, and check the Multiply box, then OK Vaya con Dios, Chuck, CABGx3 "1number" wrote in message ... I have a price list that I need to convert entire columns by either dividing them or multipication. Is there a formula to do this. -- Dave Peterson |
#5
|
|||
|
|||
And when Paste Specialling hit OK then Esc.
Gord Dibben Excel MVP On Sat, 05 Mar 2005 11:55:11 -0600, Dave Peterson wrote: How did you copy that cell? Did you copy the contents from the formula bar or did you select the cell then Edit|copy? If you didn't use Edit|Copy (or rightclick copy or ctrl-c), then try it that way. 1number wrote: When I do the .Paste Special all I see is Text and Unicode Text. Also when I try to highlight the cells it changes them all to the same number. "CLR" wrote: Enter your multiplier in an unused cell, NOT in the column you're going to multiply, then right-click on it and do Copy, then highlight the cells to be multiplied and do .PasteSpecial, and check the Multiply box, then OK Vaya con Dios, Chuck, CABGx3 "1number" wrote in message ... I have a price list that I need to convert entire columns by either dividing them or multipication. Is there a formula to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I divide a column at the first "space" occurance | Excel Worksheet Functions | |||
how do I reverse an entire column of names that have the last nam. | Excel Discussion (Misc queries) | |||
How to add the same value to an entire column? | Excel Discussion (Misc queries) | |||
How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
copying conditional formatting to an entire column | Excel Discussion (Misc queries) |