Excel is giving me zeros

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?
 
P

Pete_UK

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
 
D

Dave Peterson

Is calculation set to manual?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top