Automatic CSV Data Conversion


G

Guest

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!
 
Ad

Advertisements

D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top