View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stealth_scorpio Stealth_scorpio is offline
external usenet poster
 
Posts: 2
Default Dates not entered correctly

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,