Try 04-Oct

It would depend upon your windows regional settings which value you get.


Gord Dibben MS Excel MVP


On Sat, 4 Oct 2008 05:13:00 -0700, Stealth_scorpio
wrote:

Hi

I have Excel 2003 (11.8220.8221) SP3 running on Vista Ultimate SP1 and have
a weird glitch.

Whenever I try to enter a date such as todays date, Oct 4, into Excel - it
inputs it as Oct 1, 2004. It takes my day input as a year... How do I fix it
so it returns to normal and output the proper month/day instead of
month/year.

I have never seen this issue before in any previous version of Excel.

Any help would be appreciated as it is starting to get anoying entering the
year everytime.

Thanks,