Automatic CSV Data Conversion

  • Thread starter Guillaume Genest
  • Start date
G

Guillaume Genest

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

Similar Threads

How to map SharePoint drives permanently 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Adding data to MS Access from csv file 0
Messages showing in "Find related" but not in Conversation view 0
How can I set up Excel 97 to automatically convert/open .csv files 1
Default local file location - folder redirection slowness 0
Excel opening 1
Excel CSV Files; Creating Of 3

Top