Value or Formula
 

How can I enter a value in a cell that contains a formula but without
deleting the formua?

Value or Formula
 

Can't be done. You can have either a value, or a formula, in a cell, but not
both.

Regards,
Fred

"Zapatera" wrote in message
...
How can I enter a value in a cell that contains a formula but without
deleting the formua?

Value or Formula
 

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?

Value or Formula
 

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?

Value or Formula
 

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?

Value or Formula
 

As others have pointed out...........cannot be done.

Post a description of what you are trying to do.

There may another way.


Gord Dibben MS Excel MVP

On Tue, 23 Mar 2010 14:47:01 -0700, Zapatera
wrote:

How can I enter a value in a cell that contains a formula but without
deleting the formua?