last digit

[Guest]

how would i go about getting the last digit in a number. for example 5326 it
will return 6, 42 will return 2.
i think theres an equation for this too but im not sure
thanks in advance

 

[Oliver Ferns via OfficeKB.com]

=Right(A1,1) where A1 contains the value


Hth,
Oli

 

[Guest]

You can use the "RIGHT" worksheet function.

Cheers,

Mike

 

[Thomas Ramel]

Grüezi choice

choice schrieb am 11.02.2005

how would i go about getting the last digit in a number. for example 5326 it
will return 6, 42 will return 2.
i think theres an equation for this too but im not sure

If you have numbers only you can do this mathematically instead of
string-operations:

=MOD(A1;10)




Regards
Thomas Ramel

 

[Guest]

This one is close, but does not quite work all the time. Try 12000.

 

[Tom Ogilvy]

Returns zero for me. What do you get?

 

[Myrna Larson]

Assuming the number is an integer, =MOD(A1,10)