On Tue, 12 Nov 2002 13:49, Joseph Braddock wrote: > 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
Or make a second cell your destination... record a macro of Joeb's copy and paste. Then whenever you want too, run the macro. -- Michael
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com