Auto number column does not start from 1
I have just added a new auto number column in my sheet and although I left the "fill" and "suffix" section blank, when I click on save the numbering in the column starts from "KX BOND 478" rather than "KX BOND 1". Can anyone please clarify why the auto numbering doesn't start from 1? If I am not able to fix this issue by making further updates to the column, is there any way you can suggest me with a formula such that row 1 is KX BOND 1, row 2 is KX BOND 2, row 3 is KX BOND 3, etc...
Help Article Resources
Check out the Formula Handbook template!