Opening .csv-files in Excel
I'm not sure, but it might be that on your computer the list separator is set to a semicolon, while on the other it is a space (or
even something else)
look in Control Panel, Date, Time. Language and Regional Options
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"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?
|
|
|
|
|
|
|
|
|
|
|