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

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.

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...




In article ,
"Chris" wrote:

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.

Try changing the cell format to Date.

--
Regards;
Rob
------------------------------------------------------------------------
"Chris" wrote in message
...
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.

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.
....

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

In article .com,
"Harlan Grove" wrote:

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

OK... 38364 "Excel days" <g

Maybe you're viewing formulas:

Tools|options|View Tab|uncheck formulas.



Chris wrote:

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.

--

Dave Peterson