At 10:54 19/11/2007 -0500, Lloyd Noname wrote:
Hi i have open office on two computers, I had Excel on an old one The problem i have is moving formulas With excel i could remove the formula & leave the numbers so the numbers could be moved, With open office if i delete the formulas it also removes the numbers, Is there a way to do this in open office
Just as in so many situations, Paste Special is your friend! Copy the cell or cells and then paste back into the same cells. But instead of using the normal paste, use Edit | Paste Special... (or right-click | Paste Special... or just Ctrl+Shift+V). In the Paste Special dialogue, remove the tick from "Paste all" if necessary and then make sure that Numbers is ticked but Formulas is *not* ticked. This freezes the results of your calculations, rather than keeping the recipe for calculating them - which is what you need.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
