Re: Creating Excel File from SQR (numeric text)

[Greg Hesla <ghesla@CIMACONSULTING.COM>]

The quickest way to fix this is to change the extension from .csv to .txt,
then import it into Excel as a delimited file, with commas being the
delimiter. When you get to the part where you designate field types,
designate this field as a text field and it will include the preceeding
zeros.

Greg

----- Original Message -----
From: Dominick LoGiudice <dlogiudice@PINE.VPCC.SUNYSB.EDU>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Sent: Friday, October 01, 1999 12:14 PM
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?
>