| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace update year in date
because of data entry errors I have a large number of birthdates that have
been entered with the year 20**instead of 19**. These are formatted in date format and I am using Excel 2003 in XP Pro. Can someone suggest a way of correcting this? Thanks in advance -- Jeff C Live Well .. Be Happy In All You Do |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date question? update year. | Excel Worksheet Functions | |||
| Find and Replace Vs Update Values In | Excel Worksheet Functions | |||
| Customized Find/Replace to Update Numbers Using Specified Criteria | Excel Discussion (Misc queries) | |||
| find, replace, update links | Excel Discussion (Misc queries) | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
Threaded Mode
