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

T

thechad987

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

David Biddulph

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

Max

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?
 
Top