Altering an Entire Column of Data

S

silva

After entering well over one hundred items in a column (and in several
adjoining columns, as well), a revelation came upon me as I discovered that
the decimal position in the data was incorrect. For example, 15386.45 should
have been 153864.5. Is there some way to correct all this data without having
to edit each cell individually? I'm using Excel 2003.
 
S

Sheeloo

Fortunately yes :)

Enter 10 anywhere in your worksheet.
Copy the cell with 10.
Select your entire columns
Right click and choose Paste Special (or from Edit menu)
Click on MULTIPLY and Click OK

Voila...

This will essentially multiply the current values by 10... I think that is
what you want.
 
D

Dave Peterson

Put 10 in an empty cell
Copy that cell

Select the range to fix
Edit|Copy|paste special|check Multiply and values

Clear the cell with the 10 in it.
 
E

Elkar

So, you basically just need to multiply everything by 10?

Enter a 10 into any unused cell
Copy that cell
Select your range of data to modify
From the Edit Menu, choose "Paste Special..."
Check the "Multiply" option
Click OK
Delete the 10 you entered originally

HTH
Elkar
 
S

silva

Excellent! Thank you everybody! I never paid any attention to that section of
"Paste Special". Now I know... And knowledge is power!
 
Top