|If the format of the cell is stuck on Text (which Excel has been known to do) the formula will show and not be treated as a formula.|
Sometimes even Format...Cells...Number (or whatever) won't change it.
Try another cell and see if you can get the formula to work. If so, select that cell, click the Format Painter icon and then click the troublesome cell.
Let us know if that works.