Re: [sqr-users] RE: preserving "leading zeros" in a string

[don.barclay@srs.gov]

Are you using excel to open the csv file?  The leading zeros may very well 
exist in the file, but excel will try to format anything that it thinks is 
a number as a number, and will "remove" leading zeros.

Try opening the file using a text editor to see if leading zeros are truly 
missing.

If you want to be able to open the csv in excel and still see the leading 
zeros, you will need to surround the value in quotes, and precede it with 
an equal sign  ( ="001111" ) so that excel will display the value as 
001111.

Hope this helps...

Don

> Hello,
> 
> I am exporting string values (which may contain numeric values) into a 
csv 
> file. Some of these numeric values may contain leading zeros (for 
example, 
> 001111, 02222...)  When the import is complete, leading zeros are lost. 
> (1111, 2222). How can these leading zeros be preserved?
> 
> Thanks for your help!

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users