You could use Tools/ Protection, and protect the sheet, not allowing users
to select locked cells. Format Cells/ Protection will allow you to set
which cells are locked. This protection isn't very secure, as Excel
passwords can easily be cracked, so if you really don't want the formula
visible, don't put it in Excel.
--
David Biddulph

"Narendra Boga" wrote in message
...
Hi All.

Could you please tell, how to hide the formulas entere into a cell. That
should be invisible to others who are in shared network, but the result
should visible.

And that should be desplayed on other words instead of the formula.

for example:

A3 cell consists formula =a1+a2;
after entering the formula, in formula bar "=a1+a2" should not display
instead "sum" should display or the formula shold not disply.

please help me.

Narendra