Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Save as .csv file removes trailing 00
Hi all.
I have a XL sheet with one column containing tekst and values. It is partnumbers. Some of these starts with trailing nulls (the number 0). Like 00AB25 or 00056P-SDF. It is populated from SQL Server 2000 varchar(30) field. When I save as .csv file XL removes the trailing 0's and the partnumber in the csv file changes to AB25 and 56P-SDF. Any ideas how to avoid this? thanx. geir |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as .csv file removes trailing 00 | Excel Discussion (Misc queries) | |||
save .csv file to .sdf file | Excel Discussion (Misc queries) | |||
why cant i see .csv as save file type | Excel Discussion (Misc queries) | |||
can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
.CSV file format - comma or semi-colon | Excel Worksheet Functions |