CSV to Excel – keep leading zeros
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 Continue reading CSV to Excel – keep leading zeros