A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi TERI,
Thank you for sharing your concern.
This happens because Excel supports only 15 digits of precision for values recognized as numbers. Therefore, an 18-digit ID may be displayed in scientific notation, and digits after the 15th position may be replaced with zeros.
Formatting the column as Text after the IDs have already been entered or imported will not restore any digits that Excel has already changed.
To prevent this issue:
- Format the destination column as Text before entering or pasting the IDs.
- If importing the data, use Data > From Text/CSV and set the ID column’s data type to Text during the import.
- After saving the file as CSV, verify it using a text editor such as Notepad rather than reopening it directly in Excel. CSV files do not retain Excel formatting, and Excel may automatically interpret the IDs as numbers again when the file is reopened.
- Keep the original
.xlsxfile as a backup before exporting it to CSV.
If the existing IDs already end in zeros, you will need to retrieve the original values from the source data or a backup, as the lost digits cannot be recovered from the affected Excel file.
For additional guidance, you may find these articles helpful:
I hope this information is helpful. Should you have any further questions or need additional assistance, please feel free to share them in the comments below. I will be happy to help.
If the answer is helpful, please click "Yes" and kindly upvote it.
Note: Follow the steps in the forum documentation to enable email notifications if you want to receive email notifications related to this topic.