I am trying to import a .csv database with 8000 products. Each price is in decimal form, as you know actinic cannot import decimals, how on EXCEL do I change the prices in one go for the WHOLE column? What is the forumla? I know how to multiply one field but I cannot seem to do it for a whole column, any suggestions?
-
-
Enter the formula into the cell on the first row.
Then select that cell and copy it to the clipboard.
Select all the cells in that column that require the formula.
Paste the content of the clipboard.
This works because Excel does its clever thing of changing the cell reference to the appropriate relative cell reference.
e.g.
Cell A2 contains 1.23, Cell B2 contains =A2*100.
Copy B2, Select B2 through B8000, Paste.
Cell B2, B3... now contain =A2*100, =A3*100... and so on.Chris Brown
Comment