Re: Output from PF to Excel XLS file in IFS

[meovino@xxxxxxxxxxxxxxxxx]

Believe me, I thought that was going to do that for me.  I've been doing
that going back to Lotus 1-2-3 for DOS!

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/10/03 01:16 PM                                           
                                          
                    Please respond to                                           
                                          
                    Midrange Systems                                            
                                          
                    Technical Discussion                                        
                                          
                                                                                
                                          
                                                                                
                                          





Mike,

well, i'll be darned - you're right.   I tried it and it did show the
apostrophe.  i even saved it as an xls and re-opened it.  same thing.  I
was going on memory only, and obviously my memory isn't what it used to be.

i wonder what i was thinking, 'cause i know that it solved a problem i
previously had with excel doing something to a number that i didn't want it
to.

oh well, i stand corrected....

rick


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

-------my message----
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)