date/number issue
 

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

date/number issue
 

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

In xl2003, Tools|Autocorrect Options|autocorrect tab.

Aniko wrote:

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

date/number issue
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Aniko" wrote in message ...
|
| 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
|

date/number issue
 

THANKS DAVE, surely it was an autocorrect problem!!


"Dave Peterson" wrote:

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

In xl2003, Tools|Autocorrect Options|autocorrect tab.

Aniko wrote:

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

date/number issue
 

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


"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Aniko" wrote in message ...
|
| 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
|