Hi nsv,
What language version do you use? I experienced that it depends on language
version. US version uses the original comma, my Hungarian version uses
semicolon, once I read in an old thread, that Swedish version also uses
semicolon. I was told that it is defined by Windows' list separator
(International settings), but changing it had no effect on Xl's behaviour.

Regards,
Stefi


€žnsv€� ezt Ã*rta:


In the raw .csv file the leading nulls are preserved (try opening it
with Notepad and you will see), but when Excel reopens the file it
converts them to numbers. But only those partnumbers that do not
contain letters.

It is a clumsy solution, but you can rename your .csv to .txt. When you
then open it you get to choose Delimited (next), Comma (next) and
finally Column data format = text.

By the way, anyone know why my .csv files are actually semikolon
delimited?


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=466716