no cell results from formula

[Abram]

Often, in Microsoft Excel 2003, when I put a formula in a cell th
results do not show in the cell. For example, today it was a simpl
+b6-b7; Each of these cells had numbers in them - 15,000 and 10,00
respectively, yet the cell showed zero. Automatic calc was on.
tried that same formula in several cells and they all showed zero. Ca
anyone help

 

[Debra Dalgleish]

Perhaps they look like numbers, but are being treated as text. You can
use one of the techniques here to convert them:

http://www.contextures.com/xlDataEntry03.html