Re: Getting a file to excel

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

A kn own Excel
bugg...http://support.microsoft.com/?scid=kb;en-us;269370...because MS is
adhering to a standard...for a change.

But...a credit card number *is* text...you won't be doing calculations with
it.

On 6/28/06, Alan Shore <AlanShore@xxxxxxxx> wrote:
> That's what I thought.
> Try typing the following into an excel cell
> 123456789123456789
> and tell me what you get.
> The only way around this is by typing a single quote before you type
> 123456789123456789, making the cell a text format, but when we applied
> this
> idea to our problem, the result showed leading zeroes. Even though this
> was
> NOT incorrect, it looked weird for our users when they know that,  the
> particular field was a credit card.
>
>
> Alan Shore
>
> NBTY, Inc
> (631) 244-2000 ext. 5019
> AShore@xxxxxxxx
>
>
>
>              <Matt.Haas@thomso
>              n.com>
>              Sent by:                                                   To
>              rpg400-l-bounces@         <rpg400-l@xxxxxxxxxxxx>
>              midrange.com                                               cc
>
>                                                                    Subject
>              06/28/2006 04:25          RE: Getting a file to excel
>              PM
>
>
>              Please respond to
>               RPG programming
>               on the AS400 /
>                   iSeries
>              <rpg400-l@midrang
>                   e.com>
>
>
>
>
>
>
> That only holds true for text files and there is a work around for it
> but I don't recall what it is (searching on WEB-400 might turn it up).
> For true Excel files, you can specify the data type for each cell and
> it's not a problem.
>
> Matt
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
> Sent: Wednesday, June 28, 2006 4:02 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Getting a file to excel
>
>
> Be careful with attempting to put data into an excel spreadsheet.
> One of the problems we have (and if anyone can post an answer to this,
> we
> would be very grateful), is that a credit card number is held in a 19
> digit
> numeric field. Once this field is placed into an excel spreadsheet,
> excel
> will only display the first 15 numbers, 0 filling the rest - NO MATTER
> what
> the rest is.
> I know this is a problem with excel, but, like I said,  if anyone has an
> answer....
>
>
> Alan Shore
>
> NBTY, Inc
> (631) 244-2000 ext. 5019
> AShore@xxxxxxxx
>
>
>
>
>              steema@diskhaven.
>
>              com
>
>              Sent by:
> To
>              rpg400-l-bounces@         rpg400-l@xxxxxxxxxxxx
>
>              midrange.com
> cc
>                                        midrange-l@xxxxxxxxxxxx
>
>
> Subject
>              06/28/2006 09:16          Getting a file to excel
>
>              AM
>
>
>
>
>
>              Please respond to
>
>               RPG programming
>
>               on the AS400 /
>
>                   iSeries
>
>              <rpg400-l@midrang
>
>                   e.com>
>
>
>
>
>
>
>
>
>
> HI What are some of the methods in taking a file that was generated by
> an
> RPG program and getting it to the user in an Excel Worksheet file?
>
> It seems to be a straightforward file. Is there a preferred method. Any
> issues w/ v5.3 and the client access ?
>
> Thanks,
> Steve
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.