CSV file

Mara · May 8th, 2002, 09:16 AM

Hi,
when I save an Excel file as a CSV file (Comma delimited *.csv) on a PC, it is created with comma (,) separator.

If I do the same things on another PC, the CSV file is created with semicolon (

separator.

Why?

Thanks in advance.
Mara

Mark W. · May 8th, 2002, 10:51 AM

Check the Number List separator value in the Regional Settings Control Panel.

Mara · May 9th, 2002, 04:11 AM

I tried on both PC, but nothing changed!

Thanks
Mara

Mark W. · May 9th, 2002, 10:44 AM

Quote:

On 2002-05-09 03:11, Mara wrote:
I tried on both PC, but nothing changed!

Thanks
Mara

Tried what?

Jack in the UK · May 9th, 2002, 01:39 PM

you need to tell us / MArk W waht the settuings were and waht you have tried to edit then to

Mara · May 10th, 2002, 04:10 AM

The problem is:

I have 2 PC: the first has the Regional Settings setted to Italian Standard
and the second is setted to English United States.
The standard list separator is ";" for Italian and "," for English.
The respective CSV files are created with the right separator.

If I change the List Separator in Italian Regional Settings to "," the
CSV file is still created with ";" separator.

If I change Regional Setting Italian to English, the CSV file is created with "," separator.

I would like to have Italian Regional settings and "," as CSV separator

Ciao
Mara

May 9th, 2002, 01:39 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	you need to tell us / MArk W waht the settuings were and waht you have tried to edit then to __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 09:16 AM	#1
Mara New Member Join Date: May 2002 Posts: 3	Hi, when I save an Excel file as a CSV file (Comma delimited *.csv) on a PC, it is created with comma (,) separator. If I do the same things on another PC, the CSV file is created with semicolon ( separator. Why? Thanks in advance. Mara

May 8th, 2002, 10:51 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Check the Number List separator value in the Regional Settings Control Panel.

May 9th, 2002, 04:11 AM	#3
Mara New Member Join Date: May 2002 Posts: 3	I tried on both PC, but nothing changed! Thanks Mara

May 10th, 2002, 04:10 AM	#6
Mara New Member Join Date: May 2002 Posts: 3	The problem is: I have 2 PC: the first has the Regional Settings setted to Italian Standard and the second is setted to English United States. The standard list separator is ";" for Italian and "," for English. The respective CSV files are created with the right separator. If I change the List Separator in Italian Regional Settings to "," the CSV file is still created with ";" separator. If I change Regional Setting Italian to English, the CSV file is created with "," separator. I would like to have Italian Regional settings and "," as CSV separator Ciao Mara