How do i keep Leading zeros in .CSV file saved as from .xls file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using VBA for saving one worksheet as .csv file format from a Excel
workbook .One of the columns in that contains values as 00033 and so on.When
my save as statement in vba code executes then i lost the leading zeroes from
that column and finally get only 33 . Is there any way by which i can keep
leading zeroes in that perticuler column.
 
Rename the file a .TXT file and then import. Excel will give you options to choose between Date, text, number, etc.
 
Back
Top