ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CSV files (https://www.excelbanter.com/excel-programming/329712-csv-files.html)

Atle

CSV files
 
Is it possible to open a csv file in excel AND make it look ok, just by
klicking it? The enteries are separated by ";". Kan I do something
to make this possible. I know i can open it whith the help of the wizard, but
i want to avoid that. Thanks in advance.
Atle


NickHK

CSV files
 
Atle,
In your Regional Options, which character do you have a list separator ?
I bet it is not the ";" used in your .csv files.

These need to match.

NickHK

"Atle" wrote in message
...
Is it possible to open a csv file in excel AND make it look ok, just by
klicking it? The enteries are separated by ";". Kan I do something
to make this possible. I know i can open it whith the help of the wizard,

but
i want to avoid that. Thanks in advance.
Atle





All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com