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!


Posted on Jan 19, 2022 5:25 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

numbers sorting

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.