| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Date incorrect in excel
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? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date incorrect in excel
Insure that your Windows settings are correct:
Start Settings Control Panel Date and Time -- Gary's Student "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? |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
| Excel file modification date | Excel Discussion (Misc queries) | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
| In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
Linear Mode
