| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| altering text to other column | Excel Worksheet Functions | |||
| Do same operation on an entire column and put the data in the col itself | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
| Altering data that was called with LOOKUP | Excel Discussion (Misc queries) | |||
| Changing entire column data | Excel Discussion (Misc queries) | |||
Threaded Mode
