Hi
Know when Excel recognizes a number as text?
How to solve this in macro? Say in macro why I have to do this on multiple worksheets with MANY cells in which this problem occurs.

Like the number problem I have a similar problem on a formula that Excel is recognizing as #Name?. I know what You thought, but the formula is correct. Is a simple If, see exactly what is typed in the cell = IF (B5 = "2", "two is"; "Another thing")

If I enter the cell and press enter (press F2 and enter, even without changing anything) Excel recognizes the formula. But like as the problem of numbers recognized as text, I can not edit cell by cell. I need a macro to solve this problem happens in 12 columns of my spreadsheet with over 5,000 rows ¬ ¬

Sorry for the first language mistake. I have arranged my question, now in english.
Any idea? Thanks