Dates
 

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?
--
--"The second hand unwinds..."--

Vaya con Dios, my darling;
Vaya con Dios my love.

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?

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

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?
--
--"The second hand unwinds..."--

Vaya con Dios, my darling;
Vaya con Dios my love.

--

Dave Peterson

Yay! It Worked!!! Muchas gracias por todo!
--
--"The second hand unwinds..."--

Vaya con Dios, my darling;
Vaya con Dios my love.


"Dave Peterson" wrote:

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

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?
--
--"The second hand unwinds..."--

Vaya con Dios, my darling;
Vaya con Dios my love.

--

Dave Peterson