Dates

L

Lost at Sea

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?
 
J

JE McGimpsey

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

Dave Peterson

Make sure that those offending cells are formatted as a date--it sounds like
it's set to some sort of number.

If all your dates look like this, then make sure you're not looking at formulas:
tools|options|view tab|Uncheck formulas
 
Top