Forum Discussion
SelinaKnow
Nov 09, 2026Iron Contributor
How do you stop Excel from removing leading zeros?
When opening a CSV in Excel, product codes such as “00125” can become “125.” This causes problems when matching them against the original records. What’s the simplest way to preserve leading zeros, ...
AndreasKiller
Nov 09, 2026Tin Contributor
Here's the full article how to stop automatic data conversations when opening CSV-files:
https://support.microsoft.com/en-us/excel/set-automatic-data-conversions
Note: The option to stop this conversation is only availbe in Excel 2024 and above!
Do not share CSV files with people who do not understand to import data correctly, share the data as Excel file. In previous versions you must import the CSV file using Data \ From File \ From CSV and transform the data to preserve the numbers as text.
Andreas.