ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   French Version of Excel saving CSV Files with a semi-colon (https://www.excelbanter.com/excel-discussion-misc-queries/45339-french-version-excel-saving-csv-files-semi-colon.html)

jr

French Version of Excel saving CSV Files with a semi-colon
 
When using a French version of Excel XP I am running into a problem with the
save as feature. I am attempting to save a contact list as a comma separated
file so users using older versions of office will be able to import the list
into outlook. When I try to save the file as a comma separated file it uses
a semi-colon instead of a simple comma. I believe this is strictly a
language issue and need to know if there is a fix or a setting I can change
somewhere. Please help

Dave Peterson

Try changing your windows list separator.

windows start button|control panel|regional and language options
regional options tab|click the customize button
On the number tab, change the list separator to a comma.

But many European users use a semicolon for this separator.

jr wrote:

When using a French version of Excel XP I am running into a problem with the
save as feature. I am attempting to save a contact list as a comma separated
file so users using older versions of office will be able to import the list
into outlook. When I try to save the file as a comma separated file it uses
a semi-colon instead of a simple comma. I believe this is strictly a
language issue and need to know if there is a fix or a setting I can change
somewhere. Please help


--

Dave Peterson

jr

Dave,

That worked perfectly...

Thanks for the help

"Dave Peterson" wrote:

Try changing your windows list separator.

windows start button|control panel|regional and language options
regional options tab|click the customize button
On the number tab, change the list separator to a comma.

But many European users use a semicolon for this separator.

jr wrote:

When using a French version of Excel XP I am running into a problem with the
save as feature. I am attempting to save a contact list as a comma separated
file so users using older versions of office will be able to import the list
into outlook. When I try to save the file as a comma separated file it uses
a semi-colon instead of a simple comma. I believe this is strictly a
language issue and need to know if there is a fix or a setting I can change
somewhere. Please help


--

Dave Peterson



All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com