# Cannot display number format properly **URL:** \ **Category:** Ask for Help\ **Created:** [October 26, 2019, 9:32am UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403 "2019-10-26T09:32:06Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![pmhungdao](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@pmhungdao](https://community.glideapps.com/u/pmhungdao)\ **Post date:** [October 26, 2019, 9:32am UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403/1 "2019-10-26T09:32:06Z")
Hello, If I format one column to Currency, or Currency (Rounded), then the app displays the value properly (e.g $1,000). But if I change the format to Number, or #,##0, then the app display value as 1000, not 1,000 as expected. Is there any way to have the thousand separator displayed in the app? Thanks, Anh Han ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 26, 2019, 2:55pm UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403/2 "2019-10-26T14:55:59Z")
I wouldn’t rely on column formatting in the sheet. You have to remember that the sheet is just a database and it’s only intended purpose is to hold data. If you want a number to display as currency or with any particular formatting for numbers, I would set up a new column and use and arrayformula to format the value how you want it to look. You would then display that new column in your app. If you need to edit the value, you would still edit the original column. `=ARRAYFORMULA(TEXT(A2:A, "$#,###0.00"))` Purely guessing here, but the reason the Currency format may be working and the Number format isn’t, may be because the currency is getting converted to a String instead of an Number, whereas the Number format is still stored as a number behind the scenes. I strictly stay away from formatting a column within the sheet. I instead use formulas to get the results I want. ---
**Author:** ![pmhungdao](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@pmhungdao](https://community.glideapps.com/u/pmhungdao)\ **Post date:** [October 29, 2019, 8:06am UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403/3 "2019-10-29T08:06:17Z")
Thank you Jeff, that works for me on display the data properly. However, when inputing data, it seems that we will have to accept the data will be displayed as 1000, cannot be displayed 1,000. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 29, 2019, 5:33pm UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403/4 "2019-10-29T17:33:49Z")
If you are talking about the Number Entry component for example, then yes, it will not show the thousands separator. It only accepts numbers and doesn’t format as you type. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [May 26, 2020, 3:15pm UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403/5 "2020-05-26T15:15:24Z")
Hi Jeff Many thanks for your earlier help… I am having the same issue but cannot seem to resove it I am trying to get a currency result (Euros in my case) - I have tried the element of your formula **`"$#,###0.00"`** in several places in mine below but unable to get a result - where does it go and do I need to change the columns to “text” as they are set as currency - perhaps this causes a conflict. ={“Partner commision”;ArrayFormula(if(len(A2:A),(((G2:G)_(H2:H/100))_-1),""))} I am also having the same issue with Precentage % - how would it be expressed ? HELP ! Mike ---
**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 26, 2020, 3:19pm UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403/6 "2020-05-26T15:19:29Z")
Hi Mike, can you show us a screenshot of a portion of your data? What is the result you’re getting with that formula? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 26, 2020, 3:28pm UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403/7 "2020-05-26T15:28:35Z")
A lot has changed in the 7 months since this post. You can do most of this within Glide now. [https://docs.glideapps.com/all/reference/data-editor/basic-columns/number-formats](https://docs.glideapps.com/all/reference/data-editor/basic-columns/number-formats) > **[Math Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/math-column)** > > Performs instant calculations on your data ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [May 26, 2020, 3:33pm UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403/8 "2020-05-26T15:33:50Z")
Link to spreadsheet … may be more usefull - I have a copy so dont worry aboiut messing with it > **[Sheets for Copy of Agent Commission](https://docs.google.com/spreadsheets/d/1Dcm0gqgDT510e3y-5xOvRMwNPFxlNNapCYcOWTipJcs/edit?usp=sharing)** > > Commission > > Email,Name,Picture,Enter Fees TTC,Fees TTC,TVA %,Fees HT,Enter Partner agency commission %,Partner commision,Enter Private client % \[0 or 10 or 15 \],Private client commission,Enter Your Commission % eg 17.5,Enter Mandate % ie 100% /... ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [May 26, 2020, 3:45pm UTC](https://community.glideapps.com/t/cannot-display-number-format-properly/1403/9 "2020-05-26T15:45:57Z")
Link to app [https://ohilo.glideapp.io/](https://ohilo.glideapp.io/)