It's not the trim function that has a problem, but the CInt function has an error, so jump. CInt function is to convert characters into integers, and the conversion range can be -32768 to 32767. The six digits you entered are out of range, so there is an error. Can you use it? CLng function Generally speaking, it is rare for such a simple thing to make a program so complicated.