Display formulae instead of showing values in cells

[Kent]

Dear all,

I have got a worksheet with formulae in some cells, please tell how to
display formulae in these cells instead of showing the values.

Thanks


Turks

 

[Guest]

You could write a ' in front of the = then excel treats the cell as text and
not as formula.

if A1 = 1 and B1 = 2 and you enter following in c1
=A1+B1 --> 3
'=A1+B1 --> =A1+B1

hth Carlo

 

[Guest]

Tools > Options > View > Formulas

 

[Kent]

I got it.

Thanks all.


Turks

Tools > Options > View > Formulas