Sort not correctly sorting manually-entered numbers

edited 12/09/19 in Smartsheet Basics

I've got an auto-number column in one of my sheets, which has data from an excel sheet that I used prior to smartsheet. Most of the numbers in the auto-number column were from historical data and needed to be identical to that excel sheet, so I changed the column type to text/number, inserted the data with the excel's values in the "auto-number" column, and then changed the column type back to auto-number and set it to resume counting after my most recent number value.

The issue I've run into is that when I sort the row, large sections of data are moved around in the sheet and are not sorted in ascending or descending order. Any help that can be provided will be greatly appreciated.