Date incorrect in excel

B

because

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?
 
G

Gary''s Student

Insure that your Windows settings are correct:


Start > Settings > Control Panel > Date and Time
 
B

because

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get the right language when inserting a date 2
Word 2007: Was up-to-date, then a crash: I reinstalled from 2007 CD, but updates? 2
Excel suddenly crippled by Just-In-Time Debugging 2
Autofill Date in Word 15.33 for Mac 0
Date and Time Picker 6.0 0
Compare shorter date range against longer date range 2
Merging from an Excel file with graphics 1
Start a mail merge upon opening the document 1

Top