RE: Getting a file to excel

In xTools, there is an option to insert the numeric field's value as text using
this:

=TEXT("012345678901234567890")

xTools does this automatically and the number is displayed verbatim.


-Bob Cozzi
www.iSeriesTV.com
iPod your industry news instead of reading it.
Coming July 18, 2006
Ask your friends to tune into iSeriesTV.com

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On
Behalf Of Alan Shore
Sent: Wednesday, June 28, 2006 3: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.