problem with csv

A

Angelo Parente

HI
When I have my regional settings at Canada (French) and I open a CSV file it
does not
See the commas as column separators
So when you open your document it is all in one cell
But if I set myself to English (Canada) it opens like it should at each
comma it’s a new column

Does any know how to fix this please help?

Angelo
 
P

Pete_UK

Presumably you want to have the settings at Canada (French)? If you
can't find a way to change the default list separator, then you could
always use Data | Text-to-columns with comma as the separator and parse
your file into columns that way.

Hope this helps.

Pete
 
A

Angelo Parente

hi pete
thanks for the info
but i tried it and i would have to do that for each document
do you have something that would work permenant

Thanks
Angelo
 
P

Pete_UK

You could record a macro while you do it once and store the macro in
personal.xls so that you can use it whenever you need to for other .csv
files.

Hope this helps.

Pete
 
Top