Thread: How do i keep Leading zeros in .CSV file saved as from .xls file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default How do i keep Leading zeros in .CSV file saved as from .xls file
Rename the file a .TXT file and then import. Excel will give you options to choose between Date, text, number, etc.

--
Kind regards,

Niek Otten

"Vikas" wrote in message ...
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.


Reply With QuoteReply With Quote