Have you checked if the cell in question has been formatted as text?
If so format as general and re-enter the formula.