Re: Creating Excel File from SQR (numeric text)

[Robert Stojkovic <robert.stojkovic@IO-CONSULTING.COM>]

Hope this helps

Have the column be set as text in the import definition in excel

Robert



> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of Dominick LoGiudice
> Sent: Friday, October 01, 1999 9: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?
>