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:

test,00016102,test,test

Change it to:

test,="00016102",test,test