Forum Discussion
CSV format dropping leading zeros in a "general format" column
Happy New Year all! I have been trying everything I can online with no luck, and am turning to you all for help. Background…one of my work tasks is balancing and entering the details for our com...
Issue with autoconverting has a long history, you may check for example https://stackoverflow.com/questions/165042/stop-excel-from-automatically-converting-certain-text-values-to-dates. But that's if you open CSV file in Excel.
But if you save your file as CSV with leading zeros Excel doesn't remove them. You may check if open such file in Notepad
Leading zeros will be removed only if you open again your CSV file in Excel.