I am making a part number list for a set of bolts used in a machine we are building. I am importing them into a Manufacturing Resource Planning system and there are around 4,000 bolts I need to put in.

Each bolt will have the prefix "TS3030" followed by a hyphen and the bolt measurement. Example: TS3030-3.000

I need the "TS3030-" to stay for each bolt and I need the measurement increment to increase by 0.125.

I can use the handle to drag it down but it goes TS3030-3.000, 3.125, 3.250, 3.375, 3.500, 3.625, 3.750, 3.875...but instead of going to 4.000, 4.125 it goes to 3.100, 3.1125, etc.

I get what is happening, I just don't know how to increase the number in front of the decimal place instead of just adding decimal places after the decimal.

When I make another column and put just 3.000, 3.125, etc. without the "TS3030" prefix it works perfectly. Is there a way to just do it this way and put in some function that adds "TS3030-" to every cell in that column?

Thanks for the help!