Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Issue | Excel Discussion (Misc queries) | |||
Date issue | Excel Worksheet Functions | |||
Date issue | Excel Discussion (Misc queries) | |||
DATE ISSUE! | Excel Worksheet Functions | |||
Number formatting issue | Excel Worksheet Functions |