Resetting AUTO NUMBER count in column

LGraf
LGraf ✭✭✭✭

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