| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change a list of 2 digit years to 4 digit years?
I need to convert a list of dates that is formatted with 2 digit years, 89
for 1989 or 02 for 2002, to 4 digit years. The list has about 6,000 dates, so I REALLY don't want to fix it one at a time. Excel seems to know what to do, it I simply double click the date and then move off it (by click or enter key) the date is adjusted to 4 years accroding the microsoft formula (which works for ALL the dates in the list). How do I have excel do all the dates at once? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| csv files using Excel 30-99 rule for 2 digit years | Excel Discussion (Misc queries) | |||
| Recognizing 2-digit years | Excel Discussion (Misc queries) | |||
| Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
| Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) | |||
| In Excel, how can you format for 4 digit years (MM/DD/YYYY)? | Excel Discussion (Misc queries) | |||
Threaded Mode
