Hi Dave,

Can you give examples? Formulas, values, etc. Is automatic calculation
turned off? ToolsOptionsCalculation tab

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"dforty3" wrote in message
...
When I apply simple mulitiplication formulas to a spreadsheet, the formula
always returns "0" as an answer. If i select the formula field and hit
enter,
it then returns the correct result. I have all the updates. It doesn't
seem
to happen when I create a new worksheet, only when I'm doing it in someone
elses spreadsheet. There is no protection applied.

-Dave