if you select the cell, do format=Cell, select the protection tab and
select hidden and locked, then protect the worksheet, the formula will not
appear in the formula bar when the cell is selected.

--
Regards,
Tom Ogilvy

"dgmorr " wrote in message
...
Hello,

I have a problem. I have a series of cells which display calculated
averages. When the calculations are done, the value is displayed in
those cells. What I want to do is be able to hide the function when I
highlight the cell. Now, when I select the result cell, the function is
displayed in the text box at the top of the screen. How do I make is so
that the text box will display the result and not the formula, thanks.


---
Message posted from http://www.ExcelForum.com/