date format is goofy

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

I am having problems with my date formatting in cells. I
am using the format of 08/26/03. I used to be able to
just simply type in 0806 and hit enter and Excel would
auto fill the slashes and the year. Now for some reason
when I just type in 0806 I am getting a date of
3/16/1902. As far as I know I have not made any changes
to my global formatting in Excel. Please help!!!

Thanks
Wayne
 
Hello Wayne:
Try checking your system date. I have that problem also, and always it seems
the fix is different.
Try checking tools, options , calculation, and make sure the 1904 date
option is unchecked.
HTH
Take care..
 
Back
Top