Cell formulas to display result only

[bbarnes81]

I have a sheet with our cost prices and have created a simple formula to add our markup

ie =b2*1.10

When I look in the cell I can see the formula, but I don't want the customer to see the formula.

I have hidden the cost price in a hidden sheet, so I just need to format this somehow, I'm sure its simple...please.

[DonkeyOte]

If you format the cells to be both Locked & Hidden prior to protecting the sheet itself you should find associated formulas are hidden... remember to unlock any cells you want your customer to be able to change prior to protecting the sheet....
Note also that no security in XL is watertight ... if a major concern I would recommend sending them a separate version that contains no confidential information.