Have I really misunderstood your question?
=RIGHT(A1,3) will give 345 if A1 hold 12345 but it will be text\
=VALUE(RIGHT(A1,3)) will give 345 as number.
But so will =MOD(A1,1000)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
I obviously have scrambled brains today...My apologies, but I need the
last 3 numbers of any given 5 digit number using the
RIGHT_worksheet_function and this will not work with the numbers always
being different. Sorry for the confusion...I've been working with both
the LEFT and RIGHT expressions today and obviously was mixed up...


Thanks again, and any help would be much appreciated...