Returns zero for me. What do you get?

--
Regards,
Tom Ogilvy

"David" wrote in message
...
This one is close, but does not quite work all the time. Try 12000.

"Thomas Ramel" wrote:

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

--
- MVP for Microsoft-Excel -
[Win XP Pro SP-2 / xl2000 SP-3]