Double-click and open .csv file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles Ingals - 18 Apr 2007 10:00 GMT

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 ?

Reply to this Message

Nick Hodge - 18 Apr 2007 11:05 GMT

Charles

Check Tools>Options>International>Use system settings is checked. If not
check it, if it is, check the regional settings in windows

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
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

> When I double-click a .csv file on my computer, it is opened in Excel with
> the right info in the right column.
[quoted text clipped - 3 lines]
> What is the setting we have to change to have my Excel behaviour on their
> machines ?

Reply to this Message

Dave Peterson - 18 Apr 2007 14:12 GMT

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.

Signature

Dave Peterson

Reply to this Message