Lost auto date format

[Jacky Ma]

In Excel X, I can just type, say 1jan03 and it will automatically change to
1-Jan-2003 or whatever date format I set. But this feature seems lost in
Excel 2004. How to enable it?
Thanks

 

[JE McGimpsey]

In Excel X, I can just type, say 1jan03 and it will automatically change to
1-Jan-2003 or whatever date format I set. But this feature seems lost in
Excel 2004. How to enable it?

It works for me in XL04, unless the cells are formatted as Text.

 

[Bob Greenblatt]

In Excel X, I can just type, say 1jan03 and it will automatically change to
1-Jan-2003 or whatever date format I set. But this feature seems lost in
Excel 2004. How to enable it?
Thanks

In Addition to what J.E. Has said, the string you type must be recognizable
as a date according to the date settings in the Date & Time International
Preferences. For Example with US settings 31-4-03 will not be recognized as
a date, but will be if a European format was selected.