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