date/number issue

A

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
 
D

Dave Peterson

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

In xl2003, Tools|Autocorrect Options|autocorrect tab.
 
N

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
|
 
A

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
 
Top