SOLVED

Truncating a 2 digit number to 1 digit.

Copper Contributor

I want to remove the lead digit of two-digit numbers. For instance, 93 becomes 3 and 76 becomes 6. 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Sue_R-skrt 

 

 

If all of your data are 2-digits integers:  MOD(A1,10)

Thanks
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Sue_R-skrt 

 

 

If all of your data are 2-digits integers:  MOD(A1,10)

View solution in original post