Re: Creating Excel File from SQR (numeric text)

[Sam Spritzer <SSpritzer@GW.CTG.COM>]

Dom,
Chances are that you are sending the field with the leading zeroes but when you import the file you have to specify that column as text not number.
Sam

<<< Dominick LoGiudice <dlogiudice@PINE.VPCC.SUNYSB.EDU> 10/ 1 12:14p >>>
I am trying to create a .csv file from SQR.
My problem is fields like ssn which could have a leading 0.  No matter what I
try it
when I open the .csv file in excel it drops the leading 0.
"012345678" becomes 12345678.
How do you write out numeric text fields?