Resetting AUTO NUMBER count in column

I tested the AUTO NUMBER column setup in a sheet to see how it works. After deleting the column and entering a new one with the proper setup, the sheet is continuing to count starting from where the previous (deleted) column left off. So, instead of starting from QUO-0001 it starts from QUO-2467 as in the attached screenshot. When I set the starting number to 1 the preview properly displays QUO-0001 but then the sheet continues the count at a much later number regardless, as attached.
How do I reset the auto number count?
Answers
-
Hi LGraf, did you get an answer? I'm experiencing the same thing.
-
I did the same thing (delete the column with the auto numbering and create a new one) a few more times over the subsequent couple of weeks and at some point it randomly worked... That's probably not super helpful to you, so sorry about that.