I'm not quite sure I follow, but if you enter =left(a1,3)+0 you will get the number you want