software

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?

Insure that your Windows settings are correct:Start gt; Settings gt; Control Panel gt; Date and Time
--
Gary's Studentquot;becausequot; wrote:

gt; For some reason that has just started....When I type a date into Excel the
gt; year comes up wrong . For example when I type in March 1....and press
gt; enter....it comes up March 1, 2017 instead of 2006.
gt;
gt; I have tried reinstalling to no avail......any thoughts?

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.........

quot;becausequot; wrote:

gt; For some reason that has just started....When I type a date into Excel the
gt; year comes up wrong . For example when I type in March 1....and press
gt; enter....it comes up March 1, 2017 instead of 2006.
gt;
gt; I have tried reinstalling to no avail......any thoughts?