Altering an Entire Column of Data
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.
|