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
|
|||
|
|||
If you save as a TEXT file (instead of CSV), using a comma as the delimiter
and double quotes as the text delimiter, it should have an extension of TXT rather than CSV. Now when you open the file, the Text Import Wizard will come up and you can specify that this column is to be treated as Text. On Fri, 9 Sep 2005 16:38:43 +0200, "Geir Holme" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
.CSV file format - comma or semi-colon | Excel Worksheet Functions |