| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the year in a range of cells
I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to change the year from 2005 to 2006. Is there a way I can do this for all of the cells in a column? Thanks in advance for any suggestions. Lee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel how do I delete or change the name of a range of cells? | Excel Discussion (Misc queries) | |||
| adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
| How do you change the size of a range of cells in a column/row | Charts and Charting in Excel | |||
Threaded Mode
