XL stores dates as integer offsets from a base date. 38534 days after
12/31/1899 (more or less) is 7/1/2005, which is the displayed date.

Format your cells as dates rather than numbers.




In article ,
"Lost at Sea" wrote:

I am trying to insert dates into Excel. For the most part the dates show up,
but I have two cells that after I enter the date they say "38534". What is
the deal with that? I do not believe that this is caused by the formula in
the following cells because the rest of the cells are fine. Does this make
any sense?