How can I get Excel to deal with dates earlier than 1900?

November 3, 2013 at 19:58:18
Specs: Windows 7
Open Office's spreadsheet prgram shows the date 7/04/1776 as a negative number. Excel will not allow negative numbers as dates as I recall? So does Excel offer any way to deal with dates earlier than the reference date of 01/00/1900?

See More: How can I get Excel to deal with dates earlier than 1900?

Report •


#1
November 3, 2013 at 20:13:07
Google is your friend...

Which one of these (or other) solutions will work best for you depends on what you plan to do with the "early dates".

Perhaps with some more details, we can offer a solution specific to your issue.

http://j-walk.com/ss/excel/usertips...

http://exceluser.com/formulas/early...

http://j-walk.com/ss/excel/files/xd...

http://home.clara.net/daibevan/nott...

http://support.microsoft.com/?kbid=...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question