This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
my numbering sequence changed in a column
it was A1, A2, A3.......etc
It changed to A1, A11 A12...A2 A21...etc
Do not know why and need help in getting it back
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Fair point.
He will have to use one helper column and put following formula if sequence is in column A and drag down -
=--SUBSTITUTE(A1,"A","")
Now, he will to sort on this column by using entire range to revert back.
As long as there is no data associated with it - yes - that will work. Otherwise it will put bad data in the rows.
It means that you have sorted the column. Now, to revet back to this,
I'm guessing the problem occurred when "A1" grew to the point that it added a second digit. If not, then it probably had a Custom Sort List. To create a custom sort list, click the Sort & Filter icon and select Custom Sort. In the Order drop down select Custom List. Enter how you want it sort like so:
An easier approach might be to change A1 to A01. Do this for all single digit codes and then sort normally.