View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Opening .csv-files in Excel

What list separator is defined in your Windows Regional Settings? [It's a
Windows setting, not Excel.]

Try changing it from a comma to a semi-colon, then try to open your CSV.
--
David Biddulph

"Bengt" wrote in message
...
I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file and
data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel colums
as one string. I have looked a lot for a setting in Excel that contol this
import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who
shall work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?