Re: RE: Using Excel spreadsheet data on the AS/400

In my experience, if I format a column of numbers as "Text" _after_ the
column is filled, Excel treats them as text (e.g. preserving leading zeros
that are typed in). However, I've also used the apostrophe, and that may
be more reliable.

Alex writes:
>Entering numbers as text   Excel stores a number as numeric data even if
>you use the Cells command to apply the Text format to the cells that
>contain
>the numbers. To have Excel interpret numbers such as part numbers as text,
>first apply the Text format to empty cells, and then type the numbers. If
>you've already entered the numbers, apply the Text format to the cells,
>click each cell, press F2, and then press ENTER to reenter the data.


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---