Double-click and open .csv file

[Charles Ingals]

When I double-click a .csv file on my computer, it is opened in Excel with
the right info in the right column.
When my colleges do it on their computer, all the info is displayed in the
first column only.

What is the setting we have to change to have my Excel behaviour on their
machines ?

 

[Nick Hodge]

Charles

Check Tools>Options>International>Use system settings is checked. If not
check it, if it is, check the regional settings in windows
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

 

[Dave Peterson]

There's a windows setting that could be different than what the CSV file uses.

Open up the regional settings applet under control panel

In winXP:
windows start button|settings|control panel|regional and language options
On the Regional Options tab
click the Customize button

On the numbers tab, check the list separator box. Make it match what's used in
the CSV file.

Be aware that this is a windows setting and can affect other programs.