Even though the cells are formatted as numbers have you tried editing the formula or reentering it? Even if a cell is formatted as general if it was formatted as text before it will not take the change until it is edited. Also copy and paste your exact formula in your reply so we can see if there is some kind of character in the text that would cause the issue. Better yet post your book and you will have an answer very quickly.

Thanks