Suppose this:

I get a file every day that has lists of numbers in column A, beginning in row 2.

They are ALWAYS 4 digits.

I would like to append a 6 digit (text) number to the end of these numbers with a macro that pops a msgbox asking me what that 6-digit number is, then, on enter, loops through and changes all the values in column A to append the six digits to the end of them.

Got me? :)