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

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

Sounds like your "numbers" are really text.

Copy an empty cell formatted to General.

Select your range of numbers and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 08:58:06 -0700, "dforty3"
wrote:

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

Thank you Niek,

I believe that was it. I looked up auto calculation in help and found it in
options and it was set to Manual. After changing it to Automatic, the problem
seems to go away. Thanks again!

-Dave

"Niek Otten" wrote:

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