# Glide App does not take on the formatting in my attached sheet **URL:** \ **Category:** Report a Bug\ **Created:** [July 30, 2020, 5:26pm UTC](https://community.glideapps.com/t/glide-app-does-not-take-on-the-formatting-in-my-attached-sheet/13316 "2020-07-30T17:26:09Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Hersh74](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hersh74/32/11342_2.png) [@Hersh74](https://community.glideapps.com/u/Hersh74)\ **Post date:** [July 30, 2020, 5:26pm UTC](https://community.glideapps.com/t/glide-app-does-not-take-on-the-formatting-in-my-attached-sheet/13316/1 "2020-07-30T17:26:10Z")
My app’s URL: [https://ramcc.glideapp.io/](https://ramcc.glideapp.io/) Hello Guys, I’m new to Glide and just started out building an app today. Something I noticed and couldn’t get my head around was that numbers I am showcasing inside the app does not take on the same formatting as my Sheet. I have certain calculated number stats in my sheet set to 2 decimal places but in the interface it goes way beyond more than 8 decimal places. How can I change that back to 2 and why doesn’t it take on the sheet formatting itself? Thanks, Hersh. ---
**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:** [July 30, 2020, 5:30pm UTC](https://community.glideapps.com/t/glide-app-does-not-take-on-the-formatting-in-my-attached-sheet/13316/2 "2020-07-30T17:30:56Z")
Set the formatting in the glide data editor. [https://docs.glideapps.com/all/reference/data-editor/basic-columns/number-formats](https://docs.glideapps.com/all/reference/data-editor/basic-columns/number-formats) ---
**Author:** ![Hersh74](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hersh74/32/11342_2.png) [@Hersh74](https://community.glideapps.com/u/Hersh74)\ **Post date:** [July 30, 2020, 8:58pm UTC](https://community.glideapps.com/t/glide-app-does-not-take-on-the-formatting-in-my-attached-sheet/13316/3 "2020-07-30T20:58:40Z")
Thanks for the help @Jeff_Hager. That worked but I am now caught in another issue. One of the columns were earlier formatted as percentage and had 2 decimal places. I changed that to 0 decimals but the percentage formatting is now gone from the cell. How do I change that back to percentage format? ---
**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:** [July 30, 2020, 9:59pm UTC](https://community.glideapps.com/t/glide-app-does-not-take-on-the-formatting-in-my-attached-sheet/13316/4 "2020-07-30T21:59:16Z")
Do you mean the percent symbol? You can add that under Units in the same column settings that let you adjust the number of decimals. ---
**Author:** ![Hersh74](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hersh74/32/11342_2.png) [@Hersh74](https://community.glideapps.com/u/Hersh74)\ **Post date:** [July 30, 2020, 10:18pm UTC](https://community.glideapps.com/t/glide-app-does-not-take-on-the-formatting-in-my-attached-sheet/13316/5 "2020-07-30T22:18:53Z")
I have added the percent symbol and that’s fine. However, on a normal Google Sheet, when you change the number format to percentage, the sheet applies the calculation to the sheet itself. e.g. 10/100 with % formatting will automatically become 10% in the cell. But now in the Glide data sheet, it just adds the symbol at the end. So, I am seeing 0.10% in stead of the 10% normally. ---
**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:** [July 30, 2020, 10:37pm UTC](https://community.glideapps.com/t/glide-app-does-not-take-on-the-formatting-in-my-attached-sheet/13316/6 "2020-07-30T22:37:59Z")
Create a math column and multiply by 100.