Re: [PCTECH] Exprting data into Excel drops leading zero

["Adam Lang" <aalang@xxxxxxxxxxxxxxxxxxxx>]

How is Excel supposed to know? Guess?  That is the problem I am talking
about.  Surveyor/400 wasn't telling Excel they were text fields.

----- Original Message ----- 
From: "Michael Naughton" <mnaughton@xxxxxxxxxxxx>
To: "PC Technical Discussion for iSeries Users" <pctech@xxxxxxxxxxxx>
Sent: Wednesday, February 25, 2004 11:22 AM
Subject: Re: [PCTECH] Exprting data into Excel drops leading zero


> That's a nice trick, but it's still somewhat more work than simply
> downloading the data directly into Excel. Maybe I'm too lazy (didn't Larry
> Wall say laziness is one of the "three great virtues of a programmer"?
> :-), but since since DB2 knows it's a text field and CA knows it's a text
> field, I think it would be _really_ handy if Excel could somehow get the
> message that it's a text field without all that manual intervention.
>
> But then, you could fill a book with things I think would be really handy
> . . . . :-)
>
> PC Technical Discussion for iSeries Users <pctech@xxxxxxxxxxxx> writes:
> >What I just did (I've been playing with this almost all day) was to open
> >up
> >excel & then I went to || Data  ||  Get External Data  || Import Text
File
> >|| & imported the data (I had created a txt flat file first) that way.
> >Step
> >3 of 3 of the wizard let me define the "type" of column each one is & I
> >changed those columns that had numbers & I wanted to retain the leading
> >zero
> >from General to Text & the leading zeros were there.  No too much more
> >work
> >but it sure wasn't intuitive.
> >
> >I'm running Office 2000 so try it.
> >
> >Thanks - Dennis.
> >
>
>
>
> Mike Naughton
> Senior Programmer/Analyst
> Judd Wire, Inc.
> 124 Turnpike Road
> Turners Falls, MA  01376
> 413-863-4357 x444
> mnaughton@xxxxxxxxxxxx
>
> _______________________________________________
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing
list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.