Excel Treats All Dates from the Previous Century as TEXT & Can't Change Format

A

AJWatson

I would like to be able to do date math on dates from the
previous century, however these dates are all treated as
text. I can change the appearance of the date, again as
text, but I can't convert it to a real date.

Does anyone know of a function that might do this?
 
Top