Hi Marcus,

Use the RIGHT([your text]; [num. of digits]) function: e.g.

Function RIGHT ("2.3345"; 2) will return 45.

--
Best regards,
Peter Jaušovec
http://blog.jausovec.net
http://office.jausovec.net


"Marcus" je napisal:

I am lookig for a way to figure out what the last 2 digits are in a numeric
string. In my example above, I would like to know w hat the last 2 sigits
are in 2.3345 and have it return a value of 45 in a new cell.

Thank you.

Mark