12345 / 10 = 1234
12345 / 100 = 123
12345 / 1000 = 12
12345 / 10000 = 1
/Henrik.
12345 / 10 = 1234
12345 / 100 = 123
12345 / 1000 = 12
12345 / 10000 = 1
/Henrik.
This requires too many IFs....
On spectrum we had X=LEFT(Y,Z)....
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