You can use the "RIGHT" worksheet function.

Cheers,

Mike

"choice" wrote:

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