Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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
Question marked as Best reply

Posted on Jan 19, 2022 11:56 AM

Looks like it's sorting as ASCII Text & Text is Aligned centered.



1 reply

numbers sorting

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