I have a csv-file with the following content :
"column 1";"column 2";"column 3"
"column 1";01.0000;"column 3"
I have a problem with the 2nd column. In excel I want to see the same value. But if i import this csv-file into an excelsheet programmatically with querytable, the value of the second column is converted to 10.000. Putting quotes around the value in the csv-file gives the same result of 10.000.
I tried to create a custom format but did not succeed. I thought the format 00.0000 would do the job for me, but it converts the value to 010.000. I got my leading zero, but the point is at the wrong place. Probably because excels interpret it as a decimal point, but it isn't.
If I open the csv-file in excel with use of the "text importing wizard", in the 3rd step of the wizard I mark the 2nd column as text. This gives me the wanted result in excel. My big question is how can I do this programmatically?
Can anyone help me?
TIA,
Johan Beumer
Bookmarks