I have a column with hundreds of 7-digit numbers. I want to convert all of the numbers to 10-digit numbers with zeros inserted into the number, filling the first, fifth, and eigth digit. For instance, I have a 7-digit number xxxxxxx and I want to change it to yxxxyxxyxx where the y's are zeros. The solution I'm looking for will convert the entire column into 10-digit numbers in this manner.

I hope whoever reads this can understand it, as it is somewhat difficult to explain. I'm not sure if Excel is capable of inserting digits into numbers like this, but I sure hope so, as changing them all individually would be extremely tedious.