#1
|
|||
|
|||
Excel is changing dates.
I formatted my computer, and reinstalled Office. When I try to input a date in a new cell of a spreadsheet created before formatting in a column formatted as date, 11/04/14 changes to 04/20/02. Date is listed on excel formatting dialog box as 03/14/01. Thanks a lot.
Kindly, Luis. |
#2
|
|||
|
|||
What does the date on your computer say? Sometimes the Memory battery can go dead and fail to keep the date current.
|
#3
|
|||
|
|||
Date is OK. Battery did not go dead.
What happened is that during the format process I had to open the spreadsheet to work on it and used Libre Office (my laptop uses Mint Linux). Date in laptop is right also.
Thanks. |
#4
|
|||
|
|||
I see. Have you tried to see if the date is wrong when entering in a new book? If the date is correct in a new book simply copy and paste the current sheet to a new one and then save it.
|
#5
|
|||
|
|||
Issue solved
You are right, I just did that and it worked.
Thank you very much. |
#6
|
|||
|
|||
Glad to hear that worked. I read that Excel will hold the date start value in a workbook after it has been saved so that was the only explanation. Thanks for posting your results.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing Actual Finish dates changes original Finish dates | SomewhereinTX | Project | 3 | 12-20-2013 10:25 AM |
Help creating template to automate changing dates | derricks | Word VBA | 5 | 07-31-2013 10:36 AM |
Excel 2010 - Converting fractions into dates | judicial85 | Excel | 5 | 12-31-2011 07:59 AM |
Stop Word from changing Folder DATES? | binar | Word | 0 | 08-12-2010 05:53 PM |
MS Excel 2004 for Mac - copying dates between documents | BCRenton | Excel | 4 | 11-10-2009 07:28 AM |