You may hide the formula in the Formula bar. This is how to do it.
In Microsoft Excel 2003:
a. Select all the worksheet by pressing CTRL+A.
b. Go to Format menu and select Cells or Right click the Worksheet area and select
Format Cells
c. Choose Protection TAB
d. Uncheck the "Locked" option and click the OK button.
e. Select a cell or cells to hide the formula.
f. Go to Tools menu, and select Protection sub menu,and Protect Sheet
g. Put a password to unprotect the sheet.(Remember your password)and click OK button.
You will see your formula is a cell is hidden.
in Microsoft Excel 2007
a. Select all the worksheet by pressing CTRL+A.
b. Right click the worksheet area and select Format cells
c. Choose Protection TAB
d. Uncheck the "Locked" option and click the OK button.
e. Select a cell or cells to hide the formula.
f. Go to review menu, and select Protect Sheet
g. Put a password to unprotect the sheet.(Remember your password)and click OK button.
You will see your formula is a cell is hidden.