excel worksheet
 

Jn my excel worksheet, there are a few boxes, that change the data I
enter...For example row F, line 155, I type in the number 46....push the tab
for the next box and the 46 turns into 1/06/1900...What would cause this and
how do I change it?
Thanx....

excel worksheet
 

The cell is formatted as a date. Chenge it to general.

"fubar1" wrote:

Jn my excel worksheet, there are a few boxes, that change the data I
enter...For example row F, line 155, I type in the number 46....push the tab
for the next box and the 46 turns into 1/06/1900...What would cause this and
how do I change it?
Thanx....

excel worksheet
 

But 46 is 15/2/2000, so there may be some further confusion.
--
David Biddulph

"Mike" wrote in message
...
The cell is formatted as a date. Chenge it to general.

"fubar1" wrote:

Jn my excel worksheet, there are a few boxes, that change the data I
enter...For example row F, line 155, I type in the number 46....push the
tab
for the next box and the 46 turns into 1/06/1900...What would cause this
and
how do I change it?
Thanx....