View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
because
 
Posts: n/a
Default Date incorrect in excel

The System Date is fine.......

When I type in March 7, hit enter...it looks like Mar-07 in the cell...if I
click on the cell and look at the formula bar the date looks like
01-03-07.........

"because" wrote:

For some reason that has just started....When I type a date into Excel the
year comes up wrong . For example when I type in March 1....and press
enter....it comes up March 1, 2017 instead of 2006.

I have tried reinstalling to no avail......any thoughts?