Select a single, empty cell
Edit-Copy
Select all the dates
Edit-Paste Special-Add-Values

Should take care of it


"Fredgus" wrote:

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?