Sounds as though the cell has "text" format set for it. Reset the format,then edit and save the formula. Might work.