Excel is giving me zeros

Excel is giving me zeros. I'll put in a formula that very obviously
should give a non-zero result, but the cell says "0". I tried
different simple formulas, even just =93=3Df8+f9=94, but the result is 0.

The source cells have numbers entered into them. I checked formatting
of the formula cell and of the source cells. I tried different
formattings (number, percentage, etc) and they all give the result of
0.

I have other spreadsheets that do the same thing. Any idea what could
cause this?

Pete_UK
Fri May 09 07:34:17 CDT 2008

Have a look at the formatting applied to the cell - set it to General
or Number.

Also, you could check to see if you have Fixed Decimal set up - Tools
| Options | Edit tab (about halfway down) - this should be unchecked.

Hope this helps.

Pete

On May 9, 1:05=A0pm, Todd Walton <tdwal...@gmail.com> wrote:
> Excel is giving me zeros. =A0I'll put in a formula that very obviously
> should give a non-zero result, but the cell says "0". =A0I tried
> different simple formulas, even just =93=3Df8+f9=94, but the result is 0.
>
> The source cells have numbers entered into them. =A0I checked formatting
> of the formula cell and of the source cells. =A0I tried different
> formattings (number, percentage, etc) and they all give the result of
> 0.
>
> I have other spreadsheets that do the same thing. =A0Any idea what could
> cause this?

Dave
Fri May 09 09:26:53 CDT 2008

Is calculation set to manual?

In xl2003:
Tools|Options|calculation tab|check automatic

Todd Walton wrote:
>
> Excel is giving me zeros. I'll put in a formula that very obviously
> should give a non-zero result, but the cell says "0". I tried
> different simple formulas, even just ?=f8+f9?, but the result is 0.
>
> The source cells have numbers entered into them. I checked formatting
> of the formula cell and of the source cells. I tried different
> formattings (number, percentage, etc) and they all give the result of
> 0.
>
> I have other spreadsheets that do the same thing. Any idea what could
> cause this?

--

Dave Peterson

Todd
Wed Jun 04 14:31:01 CDT 2008

On May 9, 9:26=A0am, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> Is calculation set to manual?
>
> In xl2003:
> Tools|Options|calculation tab|check automatic

Thank you, Dave. This fixed it.