View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Aniko Aniko is offline
external usenet poster
 
Posts: 3
Default 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
|