Excel start options

[PhilBreau]

I have looked ad the optional switches and I'm trying to open a .CSV file and have the fields read as they were when it was a DOS file.

Eg: A record looks like this in text:
12345,1-7,8500,H07-038.

When it is opened in Excel, the second field shows as 7-Jan. How can I open the .csv file as is. I have copied the file to a .txt and specified text for each column. This is too tedious. I have a lot of files I need to do this with.

Thank you to any one who can help. It would be greatly appreciated.

 

[Dreamboat]

"I have a lot of files I need to do this with."

All at once?
One time deal or every day, week, minute, hour...?

One of our coders here could likely write you some code that would loop through a folder of documents and format them all as text and save them.

Alternatively, record yourself a macro that:

--Ctrl+A to select all
--Format-Cells, choose Text
--Ctrl+home or all your cells will be selected

Recording an Excel macro:

http://www.theofficeexperts.com/officevba.htm#ExcelVBA

Hope this helps! Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX