Problem with Excel: Simple multiplying calculations don't work.

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? Tools>Options>Calculation tab

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"dforty3" <[email protected]> wrote in message
news:[email protected]...
> 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 Special>Add>OK>Esc.


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 08:58:06 -0700, "dforty3"
<[email protected]> 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? Tools>Options>Calculation tab
>
> --
> Kind regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "dforty3" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>