Editing cell that has a formula in it, but displaying content and
 

how do you Edit a cell that has a formula in it, by displaying content and
not the formula it has in it?

Editing cell that has a formula in it, but displaying content and
 

If you want to replace a formula by its result, Copy, then Edit/ Past
Special/ Values.
--
David Biddulph

"thechad987" wrote in message
...
how do you Edit a cell that has a formula in it, by displaying content and
not the formula it has in it?

Editing cell that has a formula in it, but displaying content and
 

Reading between the lines in your post, what exactly is it that you want/need
to edit, based on the value that is currently returned by the formula? It may
be possible to enhance the existing formula to return the exact value that
you're after, hence avoiding your need to edit?
--
Max
Singapore
---
"thechad987" wrote:
how do you Edit a cell that has a formula in it, by displaying content and
not the formula it has in it?