Check your Windows regional settings. If the list separator is set to
semi-colon, rather than comma, then it should open your CSV ([SC]SV?) file
the way you want.
--
David Biddulph

"cisem" wrote in message
...

In my office ,my friend opens excel like I write. he doesnt run a macro or
anything. I suppose that it is a feature of excel.






"CLR":

What you are wanting then, will require a Macro, not just a formula or
procedure. The macro would need somewhere to reside, so would have to be
in
a Master Workbook that you would open first, then retrieve the CSV file.
If
that is the sort of solution you are looking for, post back and someone
will
help.

Vaya con Dios,
Chuck, CABGx3


"cisem" wrote:

I can do it like you say but i want it automatically . when i open the
document, it is automaticaly devided to columns.

"Jean-Guy":

Hi,

Have a look at Text to Columns under the DATA menu, if you have any
problems
post back!

Regards!
Jean-Guy

"cisem" wrote:

hello,
i have problem about csv format. when i open the document it open
like below

121;1454;6555;5423

but I want to devide the column to the columns
(all data is devided to different column)

like this=121|1454|6555|5423|

I can do it manually by using
(veri=metni sütunlara
dönüstür)

but I want it automatically