Why does Excel display 01/12/2005 as 38364 when the cell value is.

C

Chris

Excel 2000 and 2003 displays 01/12/2005 as 38364 even though the cell value
is 01/12/2005. How do I change this? If it matters, this is a shared
workbook stored on a network drive.
 
J

JE McGimpsey

XL stores dates as integral offsets from a base date. 01/12/2005 happens
to be 38,364 days after 12/31/1899.

To see the date format again, choose Format/Cell/Date...
 
H

Harlan Grove

JE McGimpsey wrote...
XL stores dates as integral offsets from a base date. 01/12/2005 happens
to be 38,364 days after 12/31/1899.
Click to expand...
....

Extra picky: 12-Jan-2005 is (38,364 - 61) days after 1-Mar-1900, giving
full disclosure of the false leap year bug.
 
Top