CSV leading zeros vanish

0
Hi there! I am working on a project where I am getting the data from database in csv format and one of the attribute of datatype string contain number that have leading zero's which are neglected by excel but I want to show it how can I do so. For example: Like my ID=0001 but in excel it gets converted to 1 only
asked
1 answers
0

If the zero's are there in the csv file, you need to fix this from the excel side. You can open Excel > open file > point to your csv. It should show a wizard where you can also define data type per column, so you can set the column with the leading zero's to string. Maybe this howto helps you out.

answered