Can I display a formula as text (instead of the value) in specific cells

G

G.R. Toro

Hi,

I would like to specify the values of the formulas in a few specific cells,
rather than the resulting numerical values. I have seen approaches to
display all the formulas in the worksheet, but that's not what I need. Is
this possible?

Thanks,

Gabriel
 
S

Sheeloo

If you enter
=A1+B1
you will get the sum of A1 and B1

But if you enter
'=A1+B1
you will see
=A1+B1

preceding anything with ' treats the entry as a text...
 
Top