Value or Formula
in [General]
|
Prev: Excel
Next: Excel Data Compression
From: Zapatera on 23 Mar 2010 17:47 How can I enter a value in a cell that contains a formula but without deleting the formua?
From: Fred Smith on 23 Mar 2010 17:50 Can't be done. You can have either a value, or a formula, in a cell, but not both. Regards, Fred "Zapatera" <Zapatera(a)discussions.microsoft.com> wrote in message news:A0049880-4259-4799-A673-DCDDA39098CB(a)microsoft.com... > How can I enter a value in a cell that contains a formula but without > deleting the formua?
From: Mike H on 23 Mar 2010 18:10 Hi, is this what you mean? =22/7 & " Is the value of Pi" -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Zapatera" wrote: > How can I enter a value in a cell that contains a formula but without > deleting the formua?
From: tompl on 23 Mar 2010 18:11 A cell can have a value or a formula, but not both. A formula usually results in a value. If cell A1 has the formula =B1, then anything you enter in B1 will show in A1. That way you can get the value of the formula in cell A1 to be what you want by entering the value in cell B1. "Zapatera" wrote: > How can I enter a value in a cell that contains a formula but without > deleting the formua?
From: Mike H on 23 Mar 2010 18:11
Hmm, I just spotted your other post with a different heading, there's no need to post multiple times you will get an answer from 1 post -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Zapatera" wrote: > How can I enter a value in a cell that contains a formula but without > deleting the formua? |