01 Jul 2010, 00:00

Excel Deletes Leading 0s When Opening a CSV File

If you want Excel to keep a field’s leading zeros when opening a CSV file using Excel, you can change it to =”value”.

For example, if you have a row with 4 values that looks like this:


Change it to: