2008/6/15 Dave Barton <[EMAIL PROTECTED]>: > I have been asked a Calc question to which my immediate thought was to > reply: "No, that is not the way spreadsheets work". On reflection, I began > to wonder if the following was possible. > > Cell A1=1 cell B1=2 cell C1=A1+B1 The result "3" is displayed in C1 > The question: "Other than over-typing the function in C1 with a number > value, is it possible to convert the result into a permanent value, which > would allow the contents of A1 and/or B1 to be deleted?" > > I don't know why the user wants to do this and I don't much care. It's more > a case of satisfying my own curiosity. > > Any thoughts? > > Dave > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
I think you were right at the very beginning: this is not how spreadsheets work. I got a similar question asked many times particularly from people wanting to reuse the C1 in a different spreadsheet/cell. Normally these people are satisfied when I point them to the way to paste only the values rather than the formulas. The long way around to achieve what you want is to 1) copy C1 2) paste special values into an empty cell (say D1) 3) copy D1 4) paste into C1 Cheers, Michele --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
