how do I hide a cell formula from the formula bar
 

I want to enter a formula in a cell - but dont want it to appear in the
formula bar.
Please let me know - how to go about it. Thanks.

how do I hide a cell formula from the formula bar
 

Hi,

It takes a few steps so instead of me explaining have a look here

http://www.techonthenet.com/excel/ce...e_formulas.php

Mike

"S. Shah" wrote:

I want to enter a formula in a cell - but dont want it to appear in the
formula bar.
Please let me know - how to go about it. Thanks.

how do I hide a cell formula from the formula bar
 

FormatCellProtectionUnlock the cell and enable Hidden

ToolsOptionsProtect Sheet................sheet MUST be protected


Gord Dibben MS Excel MVP

On Sat, 6 Dec 2008 13:40:00 -0800, S. Shah <S.
wrote:

I want to enter a formula in a cell - but dont want it to appear in the
formula bar.
Please let me know - how to go about it. Thanks.