Re: Output from PF to Excel XLS file in IFS

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)