Re: Output from PF to Excel XLS file in IFS

[meovino@xxxxxxxxxxxxxxxxx]

Richard,

I've tried that, and I swear, it shows the apostrophe.  In an XLS file, it
won't show it, it will treat the cell as text.  But in a CSV, it shows the
apostrophe.  That was the first thing I tried.

Thanks!

Mike E.




                                                                                
                                          
                    "Richard B Baird"                                           
                                          
                    <rbaird@esourceconsul       To:     Midrange Systems 
Technical Discussion <midrange-l@midrange.com>   
                    ting.com>                   cc:                             
                                          
                    Sent by:                    Subject:     Re: Output from PF 
to Excel XLS file in IFS                  
                    midrange-l-bounces@mi                                       
                                          
                    drange.com                                                  
                                          
                                                                                
                                          
                                                                                
                                          
                    02/07/03 06:41 PM                                           
                                          
                    Please respond to                                           
                                          
                    Midrange Systems                                            
                                          
                    Technical Discussion                                        
                                          
                                                                                
                                          
                                                                                
                                          





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.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.