Excel is giving me zeros

  • Thread starter Thread starter Todd Walton
  • Start date Start date
T

Todd Walton

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?
 
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
 
Is calculation set to manual?

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