Re: Creating Excel File from SQR (numeric text)

[Greg Hesla <ghesla@CIMACONSULTING.COM>]

This will just make it look like it has the leading zeros. If you attempt to
perform a lookup or comparison against another spreadsheet containing
text-formatted values, they will never be equal.

Greg

----- Original Message -----
From: Kevin Burke <burke@KCMETRO.CC.MO.US>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Sent: Friday, October 01, 1999 12:57 PM
Subject: Re: Creating Excel File from SQR (numeric text)


> In the past I have formatted the cells in Excel using
'Format/Cells/custom'
> you can then specify 000000000 or 000-00-0000 and it will keep the data
with
> zero's on the left.
>
>
> -Kevin Burke
> PeopleSoft System Administrator
> Metropolitian Community Colleges
> (816) 759-1414
> mailto:burke@kcmetro.cc.mo.us
>
> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting language
> [mailto:SQR-USERS@list.iex.net]On Behalf Of Johnson, Joe
> Sent: Friday, October 01, 1999 11:31 AM
> To: Multiple recipients of list SQR-USERS
> Subject: Re: Creating Excel File from SQR (numeric text)
>
> 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?
>