How do I add a set of numbers in front of a full column?

So, I was given a list of UPC numbers from a distributor but they only use the last half of the numbers and in order to add them to my POS software I need the full UPC.
They all start with the same number (030172) and I need to add that number to the front of all the numbers in a column. I have about 2000 items that I need to add that to so it would take forever to do it one by one.

Example:
53672-1
Needs to be 030172536721

I also need to know if there is an easy way to remove the dash (-)

Thanks in advance for all your help.

Great! That worked perfectly!
I just made a column over to the right and moved the numbers over there then put the formula into the original column!
Next question:
My POS system will only recognize the formulas now instead of the numbers, how do I switch it back to the numbers?