csv opens in one column on new computer

[kentlii]

I am working with csv files from different programs and after my old computer broke down and I got a new computer and installed excel again. (excel 2007 on both computers)
On the new computer when I open the csv files, they open with all the information in only the first column. Well, one csv actully puts some information in other columns depending on the account, but still puts the majority of the information in the first column. But on the old computer it opened the csv file and the information was divided into the columns.
Can you help me with what settings to change, to be able to get the csv files to open as they did on the old computer?

On the old computer the excel was in English and on the new in Spanish, I do not know if that has anything to say, but both were office 2007.

I cannot use the Date-separate text to columns, because it does not separate well for the csv file that puts some info in more than the first column.

 

[Andrew Poulsom]

Welcome to MrExcel.

I think Spanish Excel expects the delimiter to be a semicolon rather than a comma. Try changing the file extension to txt. When you open it you will get the Text To Columns Wizard and you can choose the delimiter.

 

[kentlii]

that does not work for me. I have to re-import it into a system (s2member) and this causes an error. With the other computer where it opened it up with the information in the different columns it worked fine with the re-import.

 

[kentlii]

Is it possible to move the configuration of excel from one harddisk to another? That might fix the problem.
Or how do I change the settings for how excel opens csv files?

 

[Andrew Poulsom]

You need to change your Regional Settings in Control Panel to English.