Re: Creating Excel File from SQR (numeric text)

["Duckworth, Jerry" <jduckworth@PSCO.COM>]

It doesn't sound like the problem is with your csv file.  This is a problem
with Excel.  Excel doesn't seem to notice the quotes around the text fields
that are numeric and will always drop the leading 0's unless you specify the
column as text when you are opening the file.

> -----Original Message-----
> From: Dominick LoGiudice [SMTP:dlogiudice@PINE.VPCC.SUNYSB.EDU]
> Sent: Friday, October 01, 1999 10:15 AM
> 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?