excel 2016 - Pre 1900 date can't be formatted

Question

I have a problem when format date with date pre 1900, as those date will not be formatted with date formatting. How to get over this problem?

Answer 1

If a date is before 01/01/1900 cannot be treated as date in Excel, you can eventually express it as a string, by using a heading apos i.e. '01/01/1888

CIT: "When you enter a date, the date is converted into a serial number that represents the number of elapsed days since January 1, 1900. For example, if you enter July 5, 1998, Excel converts the date to the serial number 35981."

More details at:

https://support.microsoft.com/en-us/help/214330/differences-between-the-1900-and-the-1904-date-system-in-excel