Altering an Entire Column of Data
Excellent! Thank you everybody! I never paid any attention to that section of
"Paste Special". Now I know... And knowledge is power!
"silva" wrote:
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.
|