Hi, all, When we input a time (e.g., 11:07) in a cell and convert it into one of a date format with time (e.g., 2008/1/29 11:07), the actual result is 1899/12/30 11:07.
I input a 0 in cell and convert it into a date format. The result is 1899/12/30. So I think program takes 0 as default date information of the missing date information of the input time. Now my questions: 1. Why 0 equals 1899/12/30? Is this a convention or a definition of Sun? 2. Is this just a date tells the users that this is not a certain date? because we can't determine the date it should be. BTW, I found in MSExcel, it converted into a "wrong" date: 1900/1/0. I guess maybe my 2nd question is the purpose? Best regards, Zhu Lihua
