Comparing Numbers When One Is Text Format And The Other Is Number Numeric Format

[Howardc]

I have a workbook containing sveral sheets, the one being "TB consolidation" where the numbers in Col B are shown a text eg '114201 and sheet TBTXT which are genuine numbers.

I have a formula in Sheet TBTXT in Col A which compares the account numbers in Col B to the existing account numbers in TB Consolidation and if a new number has ben added it must indicate "NEW" otherwise it must show a blank

I cannot get the formula to work, due to the fact that the numbers in sheet TB consolidation are shown as text and the numbers in TBTXT are shown as numbers

I have attached some sample data. It would be appreciated if you could amend the formula so that it works

Your assistance in this regard is most appreciated