numbers sorting
I am sorting a column with cells formatted as numbers with both 12 digit numbers and 13 digit numbers. When I sort the column in ascending order, the sort is only going by the first few digits in each number thus placing many 13 digit numbers before the 12 digit numbers. The the larger values (13 digit numbers) should be towards the bottom of the column. Here is a screenshot of a few lines of my ascending order. Thanks for your time and support!