View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.