# In-app sort feature not working for the price column

**URL:** <https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903>\
**Category:** Ask for Help\
**Created:** [June 11, 2021, 4:25pm UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903 "2021-06-11T16:25:14Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lydia\_21](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lydia_21/32/21635_2.png) [@Lydia\_21](https://community.glideapps.com/u/Lydia_21)\
**Post date:** [June 11, 2021, 4:25pm UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903/1 "2021-06-11T16:25:14Z")

</div>

Hi,

I have a price column for my products and trying to use the in-app sort feature to allow a user to sort the list of products by price.

Unfortunatly the feature seems to be sorting the price in a weird way. For example instead of 1.99, 2.99, 3.99, 12.99, 20.00 and 34.99, I’m getting 1.99, 12.99, 2.99, 20.00, 3.99, 34.99. So it’s only looking at the first digit rather than theentire figure. I’ve tried changing the column from text to number and vice versa and I get the same result.

Any suggestions on what I can do to fix it?

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [June 11, 2021, 5:41pm UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903/2 "2021-06-11T17:41:11Z")

</div>

Check the column type in the data editor. It’s numeric or string? May be the second.

---

<div class="post-metadata">

**Author:** ![Lydia\_21](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lydia_21/32/21635_2.png) [@Lydia\_21](https://community.glideapps.com/u/Lydia_21)\
**Post date:** [June 11, 2021, 5:50pm UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903/3 "2021-06-11T17:50:48Z")

</div>

I had it as number currency and it didn’t work. Then I changed it to just number and it worked. Thank you!

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [June 11, 2021, 5:51pm UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903/4 "2021-06-11T17:51:27Z")

</div>

You’re welcome

---

<div class="post-metadata">

**Author:** ![Lydia\_21](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lydia_21/32/21635_2.png) [@Lydia\_21](https://community.glideapps.com/u/Lydia_21)\
**Post date:** [June 14, 2021, 10:12am UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903/5 "2021-06-14T10:12:30Z")

</div>

Hi,

How do I get the currency sign (£) to appear in the inline list and the table component?

It’s in my data editor but it doesnt appear on the app.

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [June 14, 2021, 10:26am UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903/6 "2021-06-14T10:26:07Z")

</div>

If your column is numeric, you can set the symbol you need in the data editor. Now I’m not in front a computer to send you a screenshot but if you check you can found some options when you edit the column.

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [June 14, 2021, 10:33am UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903/7 "2021-06-14T10:33:00Z")

</div>

> **[Number Column](https://docs.glideapps.com/all/reference/data-editor/basic-columns/number-formats)**

---

<div class="post-metadata">

**Author:** ![Lydia\_21](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lydia_21/32/21635_2.png) [@Lydia\_21](https://community.glideapps.com/u/Lydia_21)\
**Post date:** [June 14, 2021, 11:13am UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903/8 "2021-06-14T11:13:35Z")

</div>

Thank you!!!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/in-app-sort-feature-not-working-for-the-price-column/27903/9 "2024-01-17T16:51:49Z")

</div>


