View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
silva silva is offline
external usenet poster
 
Posts: 3
Default 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.