How to fix date errors when copying to another Excel file
Often when copying date data in Excel to another file will be kept the same format, with date data. However, many cases of date errors when copying, specifically the date change error slows 4 years 1 day compared to the standard date in the data. The time when copying will deviate from the standard time, forcing users to re-enter the data.
This error is due to the calculation on Excel, because Excel will calculate the starting date from 1900-01-01 (digital form is 43101), but because the user corrects it, the starting date changes to 1904-01-01 (numeric form is 41639). This results in a change in the date when copying is performed to another Excel file. So how to fix date errors in Excel?
- Instructions on how to fix reverse dates in Excel
- How to format dates in Excel
- How to convert a sequence of numbers into dates in Excel
1. Fix date errors in Excel 2007 and above
Step 1:
In Excel file, we click on the Office icon and select Excel Options .
Step 2:
In the Options interface click on the Advanced item and scroll down under the When computing this workbook section . Then remove the product in the Use 1904 date system and press Ok to save.
2. Fix date errors in Excel 2003
This method will apply to versions from Excel 2007 and above. In case you use Excel 2003 , click on Toosl in the toolbar and then select Options .
Then in the new interface click on the Caculation section then uncheck the area in the 1904 date system , click OK to save the changes.
So with the simple way above, we have fixed the error of the date when copying date data to another file in Excel. This is due to the calculation on Excel that you have previously set.
See more:
- How to calculate the number of days in Excel
- How to display 0 in front of a number in Excel
- How to create the index on the bottom, write the exponent in Word
I wish you all success!
You should read it
- How to fix the date #VALUE error in Excel
- How to fix date format errors in Excel
- Instructions on how to fix reverse dates in Excel
- How to fix date auto-jump error in Excel
- Date Jump Error in Excel [FIXED]
- Change the slash to a dot in Excel format
- Instructions on how to insert the current date in Excel
- Reveal the secret for importing and converting date formats in Excel
- What is ### error in Excel? how to fix ### error in Excel
- How to convert a sequence of numbers into dates in Excel
- How to automatically update the Excel file editing time
- How to format dates in Excel
Maybe you are interested
Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excel
How to turn off auto formatting in Excel
Here's What to Do Before Sharing an Excel Spreadsheet
How to use the TREND function in Excel
How to create Progress Bar in Excel, conditional progress bar
How to change auto save time on Excel, Auto Save Excel File