Don't think you can - You can hide the formula so that nothing appears in the
formula bar, but I don't think you can have just the result show. To hide the
formula, you need to format the cell's protection property as hidden and then
protect the sheet, eg

Format / cells / Protection / Tick Hidden - Now on the sheet do Tools /
Protection / Protect sheet

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"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/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004