Iam accessing a csv file in visual basic program. A column in csv file has got zip codes, but there is formating problem with zip code for eg. 07001 or 08820 is displayed as 7001 or 8820. Iam not able to set the format of the column in my program .
I tried using
1) selection.numberformat = "00000"
2) selection.numberformat = "@" and then adding the leading zeros.

Can some one please suggest any solution to fix this problem of leading zero's.