Re: Creating Excel File from SQR (numeric text)

[Kevin Burke <burke@KCMETRO.CC.MO.US>]

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?