Does the sheet show the correct result when you press F9? If so, your
file is set for manual calculation. Go to Tools | Options |
Calculation (tab) and check Automatic. Save your file so that it will
be automatic when you next open it.
If not then the cell is probably pre-formatted to text. Changing the
format only comes into effect after the cell has been edited, so
double-click on that cell and then press <Enter>.
Hope this helps.
On Jul 25, 9:02 pm, Pat Adams < XXXX@XXXXX.COM >