You are mixing string with numeric values...
12345 is a decimal number.
LEN or any other similar command (LEFT, RIGHT, MID) will take as an input just string characters, not numeric values.
Ioannis
You are mixing string with numeric values...
12345 is a decimal number.
LEN or any other similar command (LEFT, RIGHT, MID) will take as an input just string characters, not numeric values.
Ioannis
Look up DIG. It isolates single digit, as you need it, without IF...
Bookmarks