I have a formulae as =Sum(H3:H6) in a cell which should display a value in
currency. No value is seen, but the grand total displayed at the end of the
sheet, including many other formulae ( shown in local currency ) includes the
missing items.

Also, how do you lock formulae without proctecting the whole sheet?