Return last digit in cell as a number

**Jogier505** · 02-20-2010, 06:27 PM

I am trying to get a formula to return the last digit from a number in a cell as a number.

If the cell (B3) contains a number such as 164 or 34 I want to return a value of 4 and have it be formated as a number.

I have tried =RIGHT(B3,1) and it returns a 4 but I cannot get another formula to recognize it as a number. It shows up in the cell on the left side as text would and if I format it as a number nothing happens it is still on the left and the formula does not work.

Thank you

Jim O

**Huron** · 02-20-2010, 06:40 PM

Try
=RIGHT(B3,1) + 0

**Jogier505** · 02-20-2010, 06:44 PM

Huron,

Thank you very much.
The little things get you every time.

JIm O

**shg** · 02-20-2010, 06:55 PM

Or =MOD(B3, 10)

**Marcol** · 02-20-2010, 06:42 PM

Try

=INT(RIGHT(B3,1))

**teylyn** · 02-20-2010, 07:12 PM

and, for completion's sake

=VALUE(RIGHT(A1,1))

**martindwilson** · 02-20-2010, 07:48 PM

btw you dont need to include 1 in right (or left) =right(a1) will do

**teylyn** · 02-20-2010, 07:59 PM

Good point, Martin. Personally, I've made it a habit to spell out all function parameters. The little added typing effort often saves me a lot of guesssing and trying to figure out what the default value is, especially when I revisit a formula after a long time.