How to extract last (end) digit of the Number value

please, how to extract last(end) digit of the Number value. e.g 235 i want to pull just the digit 5 to anther cell.

As generally in programming, you may try calculation with *mod" operator. To get the last of 3 digits:
type | name | calculation
calculate | lastDigit | ${YourNumber} mod 100

Also substr() function might help.

If you don’t now the length you could use string-length( string( ${YourNumber} ) ). You can e.g. the 100 above with it.


Thank you Wroos. :+1:

1 Like