CSV to Excel – keep leading zeros

February 9, 2010 · Posted in Windoze · Comment 

When opening a csv file in excel, leading zero’s are displaced as below:

if the CSV file has “010101″, when opened in excel, it becomes “10101″.

To overcome this issue, store data in CSV file as =”010101″ (add ‘equals’ sign before the first quote.). If now you would open this file in excel, the leading zeros will stay as is.

Tags: no tags