Making a Part# List, Sequential Increments with Letters and numbers in front...

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!

Hi kpl39

Format cells: ctrl + 1: Number > Custom > Type:
Type this in the box: "TS3030-"0.000

I found a simple way to make this work just by adding the prefix after the numbers.

I started with 3.000 then 3.125 and used the handle to drag it all the way down to 120.875. Then I added ="TS3030-"&A1 and copied this function all the way down.

Kevin, that worked perfect, thank you.

Ron, that is what I tried originally but the after 3.875, it goes to 3.1000. It just adds another 0 instead of changing the number before the decimal place.

@ kpl39

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.