Excel

Yes I believe it is possible. If you click
on the cell you want to hide and on the Format menu, click Cells and then click the Number tab. In the Catagory list, click Custom. In the type box erase what is showing and type ;;; (three semicolons). The hidden values will only appear in the formula bar. To undo this click on this box again and go back to the Custom and now click on the General and the cell will become visable again. Once you've done that then you can hide the formulas.

This can also be found through Excel Help typing in hide results.

Hope this helps.

Donald,

There are a few options. You can put the cell with the formula somewhere outside of the area the user will be working in. Or, you can hide the result by changing the font color of the cell to white (or whatever the background color is). It sounds like you're protecting the sheet (since hidden formulas are only hidden if the sheet is protected), so just make sure that the "hidden" cell is locked as well.

Hope this helps.

jpt@zasa.com has the best answer. There is
another way to do this without protecting the cells by Using Names:

Enter Formula in a cell in Absolute Reference:
Example =Sum($A$1:$A$10)+Average($A$5:$A$10)Double Click or F2 to Edit Cell
SelectEntire Formula and = then cut formula
From Menu, Insert, Name, Define...
Give a Meaningful Name
Example CostRate
Paste Formula in Refer to Field
Click OK

Create the Following Macro:
Sub HideMyFormula
ActiveWorkbook.Names.Item _
("CostRate").Visible = False
End Sub

Run the Macro

Now Enter "=CostRate" in the Cell you want the data in.

The users cannot see the formula because the
name is hidden, but they can use it on the worksheet.

Thanks for the help. It was what I needed for the spreadsheet I was working on.

Thanks,

Donald