19th century dates in Excel

D

Don G

Does anyone know how to format 19th century dates in Excel? Right now,
it's converting anything before 1904 (or 1900) to text.
 

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

Similar Threads

19th Century Calendar? 1
dates 2
Conditional Formatting 1
Creating a Search using a combo box and then creating a report. 4
Issues with 1900 & 1904 base date 0
Problem with sorting 19th century dates 2
Excel and date ranges 2
Handles Dates in 19th Century Wrong 2

Top