i enter invoice numbers even the first numbers are changing .. to enter data manually i shorten it that way... but i cant use vlookup afterwards to get other infos ..
because the cell contents are 120 and not 5200120.

so if i have to enter 100 rows with invoice numbers beginning 5200
i will have another 100 rows with 5201, then 5202 and so on .. so everytime i paste the last changing digits in order to type quickly instead 7 or 8 or 9 digits.. thats the reason what i want to accomplish to use vlookup with another list after converting to text string then change back to number as full string..

Must i go through VBA to get this result ? Whats the code?