Auto-Number Not Working
I have an Auto-Number function running in one column and after number 1966, I added information in the next row, and it spit out the number 1997. I then deleted the information in the row and then added it again and now its 1998. I added another row after and its 1999. I need the next row to be 1967. Any suggestions resolving this issue?
Unfortunately I need to keep the same numbers with each row and they are not all present. Example, I have a row with the number 1771 and the next row is 1773 because 1772 was a row I needed to remove from the sheet. that being said I cannot clear out the column and have it start at a specific number.