ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Automatic CSV Data Conversion (https://www.excelbanter.com/setting-up-configuration-excel/63652-automatic-csv-data-conversion.html)

Guillaume Genest

Automatic CSV Data Conversion
 
Hi,
We are using Excel 2003 on a Terminal server 2003.

On some user profil when i open a CSV file, excel will automaticly convert
it using ";" as separator.

On some other profil it will not.

How do i setup it so Excel may do that automaticly.

thanks!
--
Guillaume Genest
Network Administrator

Dave Peterson

Automatic CSV Data Conversion
 
I think this is a windows regional setting.

Some use the comma (,) (USA).
Some use the semicolon (;) (Europe and others).

windows start button|settings|control panel|Regional settings applet
(or regional and language options)

Click the customize button
Numbers Tab
List separator



Guillaume Genest wrote:

Hi,
We are using Excel 2003 on a Terminal server 2003.

On some user profil when i open a CSV file, excel will automaticly convert
it using ";" as separator.

On some other profil it will not.

How do i setup it so Excel may do that automaticly.

thanks!
--
Guillaume Genest
Network Administrator


--

Dave Peterson


All times are GMT +1. The time now is 06:04 PM.

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