When you click on it, the formula shows up in the cell itself, or up in the
formula bar? You can't change that, if you want to change the formula into
the value, you need to copy/edit/paste special and pick values.

"Johnny B" wrote:

Hi guys is there anyway to actually solidify the results of a formula. For
Example, if i click the cell can i see the RESULTS of the formula, rather
than the FORMULA ITSELF?
For example
Column C will say
| American Online |
But when i click it, all i see is the formula, (=SUBSTITUTE(B3,A3&", ","") ...
can i remove the formula and only see the result of the formula?