RE: Output from PF to Excel XLS file in IFS

["Art Tostaine, Jr." <art@xxxxxxxxxxx>]

>CSV won't cut it; we're doing that right now.  Excel displays numbers with
>more than 12 (?) digits in scientific notation, no matter how wide you make
>the column.  It's a "feature."  I need to be able to format that column as
>text.  If we wrap the value in double quotes with the CPYTOIMPF command,
>Excel still treats the field as a number if there's no text in the field
>(even blank spaces won't help).

I was just dealing with this yesterday.  That feature stinks.  Our user was
happy if we sent it as one big column (no comma delimited), and she just
clicks Data/Text to Columns, and it does a quick wizard (like 2 clicks), and
it formats properly.

We're going to evaluate that other XLS thingy too.

Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527