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

  • Thread starter Thread starter AJWatson
  • Start date Start date
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?
 
Back
Top