Re: Creating Excel File from SQR (numeric text)

[Todd Becker <tbecker@CCCIS.COM>]

Excel needs to know that the field is to be treated like a text field.
This can be done during the import into Excel when each columns data types
can be identified.  You might also try surrounding the value in double
quotes.  This is the default text identifier for Excel imports.

Good luck.

Todd





Dominick LoGiudice <dlogiudice@PINE.VPCC.SUNYSB.EDU> on 10/01/99 11:14:41
AM

Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Todd W Becker/IS/CCC)
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?