Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-05-2014, 01:33 PM
laqa laqa is offline Excel is changing dates. Windows 7 64bit Excel is changing dates. Office 2007
Novice
Excel is changing dates.
 
Join Date: Nov 2014
Posts: 9
laqa is on a distinguished road
Question 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.
Reply With Quote
  #2  
Old 11-05-2014, 10:04 PM
excelledsoftware excelledsoftware is offline Excel is changing dates. Windows 7 64bit Excel is changing dates. Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

What does the date on your computer say? Sometimes the Memory battery can go dead and fail to keep the date current.
Reply With Quote
  #3  
Old 11-06-2014, 01:09 AM
laqa laqa is offline Excel is changing dates. Windows 7 64bit Excel is changing dates. Office 2007
Novice
Excel is changing dates.
 
Join Date: Nov 2014
Posts: 9
laqa is on a distinguished road
Default 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.
Reply With Quote
  #4  
Old 11-06-2014, 07:36 AM
excelledsoftware excelledsoftware is offline Excel is changing dates. Windows 7 64bit Excel is changing dates. Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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.
Reply With Quote
  #5  
Old 11-06-2014, 08:01 AM
laqa laqa is offline Excel is changing dates. Windows 7 64bit Excel is changing dates. Office 2007
Novice
Excel is changing dates.
 
Join Date: Nov 2014
Posts: 9
laqa is on a distinguished road
Thumbs up Issue solved

You are right, I just did that and it worked.

Thank you very much.
Reply With Quote
  #6  
Old 11-06-2014, 07:26 PM
excelledsoftware excelledsoftware is offline Excel is changing dates. Windows 7 64bit Excel is changing dates. Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel is changing dates. Changing Actual Finish dates changes original Finish dates SomewhereinTX Project 3 12-20-2013 10:25 AM
Excel is changing dates. Help creating template to automate changing dates derricks Word VBA 5 07-31-2013 10:36 AM
Excel is changing dates. 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
Excel is changing dates. MS Excel 2004 for Mac - copying dates between documents BCRenton Excel 4 11-10-2009 07:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft