Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
Guillaume Genest
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vb code - Automatic transfer of data from one sheet to another herr_bench Excel Worksheet Functions 1 November 24th 05 12:15 AM
vb code - Automatic transfer of data from one sheet to another herr_bench Excel Worksheet Functions 0 November 23rd 05 07:11 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Daily data to weekly data conversion in Excel? dlanc Excel Worksheet Functions 1 August 9th 05 02:12 AM
automatic output from known data lsu-i-like Excel Discussion (Misc queries) 2 June 17th 05 08:22 PM


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"