Re: Output from PF to Excel XLS file in IFS

["Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>]

Mike,

this probably wont help, but a single quote at the front will format it as
text:

data,data,'1234567890.1234,moredata,etc

the above csv will come up in ms just as it appears, without the quote
(unless you look in the contents window, where it still exists)

----original message---------
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).

VB macros are not an option.  We want to mail this out to customers, from a
program that runs on schedule in batch, with no human intervention.

Mike E.