On Wed, 02 Mar 2005 22:34:43 GMT, Margaret Stanley <[EMAIL PROTECTED]> proffered, in : news:[EMAIL PROTECTED]:
> I need some help please. I am using spreadsheets with calculated > values in the cells. I would like to copy the values to a new > sheets, but without the formulae. Every think I have tried so far > copies the formulae, so that if I am not copying the columns on > which the formula depends I get an error. How do I copy value > instead of formula.? In order of importance: NEVER, EVER post your address and phone number in cyberspace. Now, to your problem. Use Edit>Paste Special and uncheck �formulas�, but make sure that �numbers� is checked. Here�s a screenshot to show what I mean: http://maxqnzs.com/oopastespecial.jpg --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
