Re: Creating Excel File from SQR (numeric text)

["Rao, Sam" <Sam_Rao@AFCC.COM>]

Preface your numeric text fields with a Single Quote (tick). This forces
Excel to treat the entry as Text.

HTH,

Sam Rao



> -----Original Message-----
> From: Dominick LoGiudice [SMTP:dlogiudice@PINE.VPCC.SUNYSB.EDU]
> Sent: Friday, October 01, 1999 11:15 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Creating Excel File from SQR (numeric text)
>
> 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?