how to make excell reconise csv

[justme1122]

Hi

Im sure there is an easy way to fix the following but I have searched and searched for an answer with no luck.

At my work (excell 1997) if I double click on a .csv file it will auto open in excell in colums. I can even use forumals from another work sheet to get data with out ever opening the file. If I open the same file at home (MS Office home and student 2010) it will open in CSV format with all data from a row in one cell. Formulars from ther wookbooks do not work unless I convert the .csv to an excell file.

So the questions are:
Is there a way to make excell 2010 to treat .csv as excell files so I can grab data from cells from other workbooks.

and if not is the a way to mass change csv to xls? Considering Im dealing with 100's of files at a time.

Thanks you so much for your time
scott

 

[GlennUK]

I haven't got 2010, so can't test for your problem ... but while you are waiting for someone else to confirm/solve the problem, can you say whether your computer settings at home are the same as at work ( i.e. field separator being "," ), and whether you're certain that the file extension really is "CSV" and not a variation on that?

 

[justme1122]

Thanks for the reply.

I can conferm that the windows global settings are the same.

As to if it is a realy CSV file or not im unsure.

This is what the data looks like when opened in notepad:

Format,Title Group,No. of Transactions,$$$ Earned (inc. GST),% No. of Transactions,% Dallors Earned,title_genreName,exspend,totalExEarned
"Unspecified, Unspecified ", ,2,8.7,0.0911992704058367,0.0999393471548302,,8.7,7914.6813
"TV, DVD ",3 Day TV Box Set 1 ,5,70.15,0.227998176014592,0.805832781943832,Drama ,63.7727,7914.6813
"TV, DVD ",3 Day TV Box Set 1 ,2,27.9,0.0911992704058367,0.320495147772386,TV Series ,25.3636,7914.6813
"TV, DVD ",3 Day TV Box Set 1 ,2,29.9,0.0911992704058367,0.343469710336715,TV Shows

 

[justme1122]

any thoughts?

 

[GlennUK]

No further thoughts ... maybe someone who has Excel 2010 has some ideas.