* Miark <[EMAIL PROTECTED]> [021111 13:38]: > Is there a way in OpenOffice Calc to convert a cell from a > formula (=A5*1.15) to a string (2.30)? To, in effect, render it?
If A5 contains 2, and B5 contains =TEXT(A5*1.15;"0.00") then B5 will show the string 2.30. If you copy this to the clipboard, and then use Paste Special to paste only strings wherever you want it. Is this what you meant? If you don't really want a string but a numeric value (instead of a formula) you can copy the formula you gave and Paste Special as numbers. -- Jan Wilson, SysAdmin _/*]; [EMAIL PROTECTED] Corozal Junior College | |:' corozal.com corozal.bz Corozal Town, Belize | /' chetumal.com & linux.bz Reg. Linux user #151611 |_/ Network, PHP, Perl, HTML
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
