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
- 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
May be interested
- How to fix font errors when copying from PDF to Wordcopying text content from pdf to word with a font error is a common mistake that perhaps anyone who works in the office has encountered. the following article shows some ways to fix font errors when copying from pdf to word.
- How to fix Errors were detected while saving files in Excel 2010in the course of working as well as creating excel data tables, you'll get a lot of errors like errors were detected while saving files in excel, affecting saving excel files.
- How to format dates in Excelformatting dates in excel makes it easier for users to enter content, shortening manual input.
- How to use TeraCopy to speed up file copyingteracopy is a software that speeds up copying files on windows, to external memory cards, usb, external hard drives, saving time even with large files.
- Fix error when Excel file is minimizedoccasionally, when printing an excel file, you often encounter a file error that is automatically shrunk. how to solve this problem is not difficult, just do it with 3 steps ...
- Change the slash to a dot in Excel formatby default, the excel date format often uses slashes, such as march 23, 2016 .... however, if your worksheet has multiple dates lists, you can use dots. in date format to make the worksheet easier to see, no glitches.
- 7 most common Excel errors for office peopleit is true that excel is not simply setting up tables and entering numbers. in fact, you will encounter a lot of problems when using this software and unfortunately not everyone knows how to fix it.
- DATE function - The date function in Excelthe date () function returns a date that is formatted corresponding to the date entered as based on the date index.
- Reveal the secret for importing and converting date formats in Exceleach type of date format you feel very picky and wordy. you find it annoying to have to enter that format.
- Date functions in Excel, DAY, WEEKDAY, MONTHdo you want to automatically update the current date, separate years or calculate the distance between two time points? the article below, free download will guide you how to do this professionally with date functions in excel.