Search:

Well, can't really use CStr(CLng(someText)) because that could be too limited, as the pasted text may exceed min/max long values. If only whole numbers are needed, the most obvious solution may be...

I might prefer this format since whole numbers are only wanted:

If IsNumeric(pastedText) Then MsgBox CStr(Format(pastedText,"#"))
Can this cause a potential problem on non-US regional settings?

Just a tip about IsNumeric(). Function can return true for strings like "&hFE", "&o34", and "2E+0". If that is ok but only 'integer' should be displayed, convert the pasted string to digits before...