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 use underline styles in Excelon excel support different underline styles, but this underlined format has all been hidden on the interface.
- How to insert content annotations on Wordin addition to inserting text captions at the foot of the word page, you can annotate content to be read immediately.
- Mind mapping in PowerPointto draw mind maps in powerpoint, you need to create a new slide and use smartart to add graphical elements. follow the steps below:
- How to fix errors automatically jumps pages on Worderrors in automatically jumping pages on word often appear when you insert a table, insert images and will be moved to a new page while the old page still has space.
- How to fix opening XML files on iTaxVieweritaxviewer is software for reading xml files that are widely used. however, there are many people who often encounter errors that cannot open xml files with itaxviewer, affecting work.
- Website helps you manage all fonts installed in your computerwith the website shared in this article, you can perform an entire preview of the font style extremely simply and quickly with just any text.