Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do same operation on an entire column and put the data in the col itself
Hi,
I have a column, A B C ===== 25,970.50 263 26,233.50 4,285.50 4,287.90 What i want to do is divide each cell in A by 10 and put the result in A itself. Is there any way to do this other than first putting the result in another column B and then copying it into A. I am sure there would a simpler way to operate an entire range of cells with a single operation/transformation. Thanx in advance ~som |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do same operation on an entire column and put the data in the col itself
Try this:
Enter 10 in an empty cell Copy that cell: EditCopy Select the range of cells in question in column A Then do: EditPaste SpecialDivideOK Clear the 10 from the helper cell Biff "som" wrote in message ups.com... Hi, I have a column, A B C ===== 25,970.50 263 26,233.50 4,285.50 4,287.90 What i want to do is divide each cell in A by 10 and put the result in A itself. Is there any way to do this other than first putting the result in another column B and then copying it into A. I am sure there would a simpler way to operate an entire range of cells with a single operation/transformation. Thanx in advance ~som |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
How to copy data validation utilizing a list to the entire column | Excel Worksheet Functions | |||
applying operation to column | Excel Discussion (Misc queries) | |||
Changing entire column data | Excel Discussion (Misc queries) |