× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. May 2003

Re: AS400 to EXCEL

Booth,

>Would Excel then decide that all the columns are character, and
>move numbers in as text? 

No.  It looks at it a cell at a time, not per column, unless you are using the
import wizard to set column types.  For example, this input:

"Field1","Field2"
"ABC","DEF"
"XYZ","123"

results in cell B3 having the numeric value 123.  Turn around and resave the
file, and the third row is written as:

"XYZ",123

Doug

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.