Hello,

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.

Hello,

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.

2 Likes

Thank you Wroos.

1 Like