Hi Macropod,

Thanks for your message first.

However, how do I change to Macro VBA? since I would like to let it check
automatically.

tlee


Hi tlee,

Try:
=MOD(A1*10,10)
copied down as far as needed

--
Cheers
macropod
[Microsoft MVP - Word]


"tlee" wrote in message
...
Hi all,

Could anyone know how to use Macro to check the last digit (1 to 9) of
the cell value?

e.g.
Cell A1 = 21, 22 ........, 29 then it will be multiply by 10
Cell A2 = 201, 202, ........., 209 then it will be multiply by 10

Thanks

Tlee