I want to do some logic based on whether an entry starts with a number. I assumed `=IF(ISNUMBER(LEFT([Primary Column]1)), "Number", "No Number")` would have worked, but it seems to always return FALSE. What am I missing?
(Also, does this forum not support tables or code formatting?)
| Primary Column | Formula | Result |
|------------------------------|--------------------------------------------------------------|-----------|
| 555 I start with a number | IF(ISNUMBER(LEFT([Primary Column]1)), "Number", "No Number") | No Number |
| I do not start with a number | IF(ISNUMBER(LEFT([Primary Column]1)), "Number", "No Number") | No Number |
| | | |
| | | |