date/number issue

[Aniko]

Hi Guys,

In excel as I type in 1 to a cell, it turns into Jan immediatley.
I tried Format > Number, it didn't work.

Please help,
Cheers

 

[Dave Peterson]

Any chance you have an entry in the autocorrect list that's jumping in.

In xl2003, Tools|Autocorrect Options|autocorrect tab.

 

[Niek Otten]

Does 2 give Feb and so on?
Does this happen to all sheets? Newly inserted ones too?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hi Guys,
|
| In excel as I type in 1 to a cell, it turns into Jan immediatley.
| I tried Format > Number, it didn't work.
|
| Please help,
| Cheers
|

 

[Aniko]

THANKS DAVE, surely it was an autocorrect problem!!

 

[Aniko]

Hi Niek,
Dave Peterson was right,
'Autocorrect' was set up so that 1 was replaced by Jan automatically.
I deleted that, problem solved.

Thanks,
Aniko