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 |
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 |