Display formulae instead of showing values in cells
 

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

Display formulae instead of showing values in cells
 

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

"Kent" wrote:

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

Display formulae instead of showing values in cells
 

Tools Options View Formulas
--
Regards - Peter


"Kent" wrote:

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

Display formulae instead of showing values in cells
 

I got it.

Thanks all.


Turks




"Peter" ...
Tools Options View Formulas
--
Regards - Peter


"Kent" wrote:

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