Re: Creating Excel File from SQR (numeric text)

[Kimberly Lawrence <Kimberly_Lawrence@CCNOTES.CCITY.COM>]

I create my files as Silk (.slk).  Then you can include formatting instructions
in the file itself.  You can check the archives for examples of silk files or
contact me directly and I would be happy to provide you with an example.




 (Embedded
 image moved   Dominick LoGiudice
 to file:      <dlogiudice@PINE.VPCC.SUNYSB.EDU>
 pic17202.pcx) 10/01/99 12:14 PM




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

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Kimberly Lawrence/MIS/Circuit City)
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?

pic17202.pcx