Tiah;

Thank you -- you are awesome :-)

I thought that it would be a simple function.

Take care.

Mark

"tiah" wrote:

Hello !

formula is :

=VALUE(RIGHT(A1,2))

RIGHT will give you last two digits

VALUE will convert the string into numeric

tiah.