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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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.
 
Harlan Grove said:
Extra picky: 12-Jan-2005 is (38,364 - 61) days after 1-Mar-1900, giving
full disclosure of the false leap year bug.
Click to expand...

OK... 38364 "Excel days" <g>
 
Maybe you're viewing formulas:

Tools|options|View Tab|uncheck formulas.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to Columns not working correctly with dates in Excel 2007 5
Cell showing date and time - precision error 2
Date is not displaying correctly 9
Date issue-displaying as 0001-01-01 5
Excel 2002 : How to eliminate the time value after the date ? 8
Excel not recognizing dates as dates 1
Simple input/display question 3
subtracting dates in an IF statement 2

Back
Top