IF(OR) Statement

Options

Trying to have a fornula recognize between a text and a number. In the example below I want to have the Job# Join several items together to build the job # and i need 00- to be added to each row as a new job is started. In doing this, the formula =IF(ISNUMBER([Neighborhood Code]@row), "00-", "") is working fine as long as its a number. Cant figure out how to make it work if its not a number. Example - 5A. Any thoughts?


Answers