Ecel Cell Format Oddity

[Frank]

I have a problem with excel that may be a result of my obliviousness,
or may be an actual problem. In short, when I enter a date, microsoft
auto formats it as a formula, adding the equal sign in front as so
=02/09/04. It does this even though the cell is formatted as a Date
cell. This happened after everything was working well for the first
100 rows or so. I tried changing the formating back and forth, but the
problem remains, and in fact if I go back to a cell which worked
correctly in the past, it now also has this problem. Previous sheets
still work fine however. I did figure out that the cells are
working from Jan 1, 1900, so the number 33 results in an entry of
02/02/00 or Feb 2, 1900. Not the most useful situation for me, as I
don't really want to compute out our present dates. Anyway, Just
wondering how I can get this switched back to a more normal date
entry.

 

[Ron Rosenfeld]

I have a problem with excel that may be a result of my obliviousness,
or may be an actual problem. In short, when I enter a date, microsoft
auto formats it as a formula, adding the equal sign in front as so
=02/09/04. It does this even though the cell is formatted as a Date
cell. This happened after everything was working well for the first
100 rows or so. I tried changing the formating back and forth, but the
problem remains, and in fact if I go back to a cell which worked
correctly in the past, it now also has this problem. Previous sheets
still work fine however. I did figure out that the cells are
working from Jan 1, 1900, so the number 33 results in an entry of
02/02/00 or Feb 2, 1900. Not the most useful situation for me, as I
don't really want to compute out our present dates. Anyway, Just
wondering how I can get this switched back to a more normal date
entry.

Tools/Options/Transition and DEselect the Sheet Options


--ron

 

[Frank]

On 13 Feb 2004 10:10:21 -0800, (e-mail address removed) (Frank) wrote:


Tools/Options/Transition and DEselect the Sheet Options


--ron

Thanks Ron! That was indeed the problem, although I'm not sure how it
occurred in the first place- the sheet is shared by my co-worker so
who knows who was playing around with it. Anyway, its always nice
when one of the Universes great mysteries is solved.

Best Regards,
-Frank