Auto Numbering

Nkeiruka. Aguocha

Hello,

On my automatic numbering, it went from DCR036 to DCR051 and I have no Idea why. Well I tried to reset it but every time I redo it, delete column, save, add new column, save start from DCR001, save...it keeps increasing instead of starting from 1 again. How do I have it to start from DCR001 again, starting from Row 1 and so on? Thank you!!

Jeff Reisman

@Nkeiruka. Aguocha I've run into this before. It jumped from 36 to 51 because at some point in the sheet's history, there were rows designated DCR037-DCR050 that were deleted from the sheet. AutoNumber columns count sequentially from the last number the assigned to a row.

I believe I did the following to start the sequence over at 1:

1. Change the column type to Text/Number.
2. Save the sheet.
3. Delete the column.
4. Create a new AutoNumber column with a different name and set it to start at 1.

Andrée Starå

Hi @Nkeiruka. Aguocha

I hope you're well and safe!

Try this.

1. Change the column properties from Auto-Number/System... to Text/Number
2. Save
3. Delete the numbers you don't want
4. Save
5. Delete the rows with the numbers you deleted
6. Save
7. Change the column back to Auto Number and change the Starting Number to the number you'd like the next added row to be
8. Save
9. Add a new row
10. Save and watch the magic happen

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@Nkeiruka. Aguocha

Step 5 and 6 isn't necessary except if they are empty except for the numbering.

Nkeiruka. Aguocha

Hello,

I tried both ways and none works...the numbers keep growing. Please assist!! Thanks!

Andrée Starå

@Nkeiruka. Aguocha

Did you remember to add the starting number?

Nkeiruka. Aguocha

Hello,

Yes, I did!! What I did differently from someone else's notes was to click "save" then clicked "refresh" and that did the trick. Thank you all for your help!!!

Andrée Starå

@Nkeiruka. Aguocha

Excellent!

You're more than welcome!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!