View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SR SR is offline
external usenet poster
 
Posts: 18
Default csv to xls - data format

Hi

I have .csv files to be opened in xls format make few corrections on the
data or number fields and save it back as .csv file.

problems:
1.when I open the .csv file as .xls, the date and numeric fields do not
match the data of .csv file. I assume it has been converted to the default
settings of the excel sheet.
2. after corrections are made, I want to save the file back to .csv file

I have never written a macro. So can one of you help.

Shanti