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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top