alphabetize list sort

Discuss using and your tips/tricks for CATraxx
Post Reply
allanwol
Posts: 3
Joined: Thu Aug 22, 2019 12:39 pm

alphabetize list sort

Post by allanwol » Wed Oct 14, 2020 5:55 pm

I am trying to sort a column by its numbers, in order, from low to high (or visa versa). By clicking on the header, the column does sort, but it sorts by tens. See picture. No matter how I have tried to adust it using List formatting etc. I cannot get it done like in Excel or Access. Is there a way to do this? I did transfer it to Excell and sorted the columns, but then I could not paste it back. Thank you for your help.
CATraxx Sort Column not Alphabetyical.png
CATraxx Sort Column not Alphabetyical.png (23.87 KiB) Viewed 23 times

User avatar
DougWilliams
Site Admin
Posts: 372
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

Re: alphabetize list sort

Post by DougWilliams » Wed Oct 14, 2020 10:20 pm

This looks like it might be text field. That's how text fields sort.
If you can, use a number field.
If you can't, to sort in order, you have to pad with a zeros
0121
0122
0123
1225
1226
1227
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

Post Reply