# Filter and Sort showing in wrong order when using numbers

**URL:** <https://community.glideapps.com/t/filter-and-sort-showing-in-wrong-order-when-using-numbers/10087>\
**Category:** Report a Bug\
**Created:** [May 31, 2020, 1:01pm UTC](https://community.glideapps.com/t/filter-and-sort-showing-in-wrong-order-when-using-numbers/10087 "2020-05-31T13:01:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Leo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leo/32/8306_2.png) [@Leo](https://community.glideapps.com/u/Leo)\
**Post date:** [May 31, 2020, 1:01pm UTC](https://community.glideapps.com/t/filter-and-sort-showing-in-wrong-order-when-using-numbers/10087/1 "2020-05-31T13:01:12Z")

</div>

Hi there!

I noticed that when you add a filter or a sort, and you sort it by something with numbers in the name, the order is incorrect. Example: It shows 1, 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9 instead of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12. It’s not a big deal, but I just wanted to let you know. 🙂

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1eafce00a5aa987d1eb98397924973813b0da540.jpeg)

Thanks!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 31, 2020, 1:04pm UTC](https://community.glideapps.com/t/filter-and-sort-showing-in-wrong-order-when-using-numbers/10087/2 "2020-05-31T13:04:03Z")

</div>

Because your sort is based on a text column, I think it’s the way it normally behaves.

---

<div class="post-metadata">

**Author:** ![Spellytics](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spellytics/32/2770_2.png) [@Spellytics](https://community.glideapps.com/u/Spellytics)\
**Post date:** [May 31, 2020, 1:14pm UTC](https://community.glideapps.com/t/filter-and-sort-showing-in-wrong-order-when-using-numbers/10087/3 "2020-05-31T13:14:27Z")

</div>

G’day Leo,

This happens when numbers are stored as a String.  
It’s not really a bug of the platform.  
Just the way data is.

To overcome this, you can:

1. Have the numbers in two digits - Lektion 01 etc.
2. Have another column to store a sort order, and sort it by this column.

Hope that helps.

---

<div class="post-metadata">

**Author:** ![Leo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leo/32/8306_2.png) [@Leo](https://community.glideapps.com/u/Leo)\
**Post date:** [May 31, 2020, 1:25pm UTC](https://community.glideapps.com/t/filter-and-sort-showing-in-wrong-order-when-using-numbers/10087/4 "2020-05-31T13:25:08Z")

</div>

Thanks so much, I’ll try that!