csv to xls - data format

[Guest]

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

 

[Dave Peterson]

Rename the .csv file to .txt
start a new workbook
record a macro when you open the file--specify the correct date format for each
date field.
keep recording when you're updating the file--if your updates are all the same
save the workbook as a .csv file
stop recording

When you want to convert another file, just rerun that macro (remembering to
rename the .csv file to .txt before you start).