On Mon, 11 Nov 2002 10:42:56 -0500 Miark <[EMAIL PROTECTED]> wrote: > 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? > > Thanks, > Miark > >
Highlight what you want to convert (ie. cell(s) with formula in it). Right click and select copy. Right click same cell(s) and select paste special. Uncheck the all box, check the numbers box and uncheck the formulas box. Click okay and you should be done. If you change your mind, ctrl-z should undo your changes. Be forwarned, though, if you save the changes, your formulas you "rendered" will be gone forever. Joeb
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
