Excel Deletes Leading 0s When Opening a CSV File

July 1st, 2010 Alex Posted in excel, perl, programming, windows | Comments Off

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

Just change it to:

test,="00016102",test,test

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.

«
»