Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value or Formula
How can I enter a value in a cell that contains a formula but without
deleting the formua? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|