Re: Creating Excel File from SQR (numeric text)

["Johnson, Joe" <JoeJo@SNELLINGCORP.COM>]

Dominick,

I had a similar problem with a txt file delimited by semi-colons.

I had a salesperson ID that would be '00000706'

In Excel, I had to format that column as Text, not as General.

Then, the leading 0's were included -- in General format, the leading 0's were lost.

HTH

Joe Johnson
Snelling and Snelling Corporation
972-776-1332


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