Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Thank you.
The dates in my Google Docs that are 12/31/99 12:00:00 AM change to 1/0/1900 when I import them to excel. How do I get the correct date or what should be the correct date/how do I fix this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Count Expr
1/1/2023
11/27/2021
10/1/2022
12/31/1899
9/1/2021
9/12/2021
9/14/2021
11/15/2020
12/31/1899
12/31/1899
9/3/2021
8/31/2021
8/18/2021
12/31/1899
8/17/2021
8/3/2021
8/25/2021
8/19/2021
9/10/2021
8/17/2021
12/31/1899
8/25/2021
12/31/1899
12/31/1899
8/29/2021
9/8/2021
12/31/1899
8/11/2021
8/11/2021
9/3/2021
8/31/2021
8/27/2021
12/31/1899
12/31/1899
12/31/1899
9/1/2021
9/9/2021
8/25/2021
9/19/2021
12/31/1899
9/9/2021
12/31/1899
12/31/1899
12/31/1899
12/1/2020
9/1/2020
12/1/2020
11/1/2021
11/1/2020
12/1/2020
12/31/1899
2/12/2021
12/31/1899
1/30/2021
12/31/1899
12/31/1899
11/2/2020
9/21/2021
12/31/1899
12/31/1899
9/10/2021
1/20/2021
3/5/2021
2/25/2021
12/1/2020
12/1/2020
12/31/1899
1/1/2021
5/27/2021
12/31/1899
9/1/2020
12/31/1899
9/19/2020
11/1/2021
12/31/1899
11/1/2020
9/21/2021
8/28/2021
9/10/2021
8/21/2021
12/6/2020
8/4/2021
7/27/2021
8/28/2021
8/14/2021
9/13/2021
8/16/2021
9/5/2021
12/31/1899
8/17/2021
11/1/2020
12/1/2020
12/1/2020
8/1/2020
6/1/2021
6/1/2020
5/18/2020
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
6/22/2020
6/15/2020
12/21/2020
6/15/2020
6/15/2020
12/31/1899
6/15/2020
6/15/2020
5/25/2020
6/1/2020
1/4/2021
2/22/2021
5/25/2020
6/22/2020
4/27/2020
7/20/2020
10/27/2020
11/6/2020
12/31/1899
7/19/2020
12/31/1899
6/15/2020
5/18/2020
5/25/2020
5/11/2020
6/15/2020
6/8/2020
4/13/2020
12/31/1899
10/12/2020
8/17/2020
9/28/2020
10/5/2020
9/21/2020
9/6/2020
12/31/1899
8/31/2020
11/2/2020
9/28/2020
8/31/2020
9/28/2020
7/13/2020
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/31/1899
12/21/2020
11/2/2020
9/14/2020
7/27/2020
6/29/2020
8/3/2020
7/27/2020
12/31/1899
12/31/1899
6/29/2020
12/31/1899
12/31/1899
12/31/1899
4/13/2020
5/4/2020
12/31/1899
12/31/1899
12/31/1899
8/3/2020
5/18/2020
5/18/2020
12/7/2020
6/8/2020
5/11/2020
5/25/2020
5/11/2020
8/10/2020
8/24/2020
8/17/2020
8/24/2020
5/18/2020
8/10/2020
8/10/2020
8/10/2020
8/17/2020
8/17/2020
7/1/2020
12/1/2020
11/15/2021
4/1/2021
12/1/2021
1/1/2022
12/31/1899
12/31/1899
12/31/2020
1/31/2021
1/31/2021
11/1/2021
10/1/2021
7/1/2021
2/1/2021
7/26/2021
3/29/2021
5/11/2021
1/1/2022
2/1/2022
10/27/2020
12/31/1899
10/10/2020
11/20/2021
12/16/2021
2/1/2022
10/5/2021
12/31/1899
6/10/2021
7/1/2020
1/1/2022
4/30/2021
4/30/2021
9/3/2020
2/28/2021
2/28/2021
4/30/2020
5/28/2020
6/1/2021
11/19/2020
10/1/2022
1/24/2020
2/5/2021
9/17/2020
7/21/2020
12/31/1899
7/20/2020
6/1/2020
12/31/1899
12/31/1899
9/9/2020
8/1/2020
2/13/2021
6/20/2020
3/1/2021
3/1/2021
12/31/1899
10/24/2020
6/16/2020
5/19/2020
8/11/2020
12/26/2020
1/17/2020
6/1/2021
6/2/2020
10/9/2020
8/10/2020
12/31/1899
10/31/2020
7/29/2020
1/19/2021
10/21/2020
4/22/2020
4/27/2020
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
3 answers
Sort by: Most helpful
-
Anonymous
2021-08-14T14:23:47+00:00 -
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
-
Anonymous
2021-08-13T06:34:30+00:00 Hi ABS99,
Thank you for posting in this Answer Community.
It seems that your issue is related to Google Docs. However, We found some related documents for your reference：How to Convert Google Sheets to Excel | Smartsheet
However, your question is related to the conversion of third-party application files to Excel files , to avoid sharing any incorrect information from our side, it’s also recommended to ask the question to the Google Docs support for a better help. Since your issue is relate to Google Docs, it is better suited to post in that community. And it has more experts in this area to help you.
Thank you for your understanding.
If I have any misunderstands, welcome to contact me. And I will further investigate it.
Best Regards,
Tin