# Glide isn't showing data as a percentage, when it is in google sheet

**URL:** https://community.glideapps.com/t/glide-isnt-showing-data-as-a-percentage-when-it-is-in-google-sheet/47740
**Category:** Ask for Help
**Created:** [August 25, 2022, 3:20pm UTC](https://community.glideapps.com/t/glide-isnt-showing-data-as-a-percentage-when-it-is-in-google-sheet/47740 "2022-08-25T15:20:24Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![EricDolence](https://avatars.discourse-cdn.com/v4/letter/e/8e7dd6/32.png) [@EricDolence](https://community.glideapps.com/u/EricDolence)
#### Post date: [August 25, 2022, 3:20pm UTC](https://community.glideapps.com/t/glide-isnt-showing-data-as-a-percentage-when-it-is-in-google-sheet/47740/1 "2022-08-25T15:20:24Z")

</div>

Hello,

I’m running into a hopefully simple issue here. I have a google sheet that has percentages typed directly into cells, no formulas or anything to calculate said percentages. In glide, that sheet shows them as decimals, and not percentages. Any ideas on how to convert to percentage or why it might be forcing it into decimals and not percentages like it is in the source google sheet? Thanks in advance!

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 25, 2022, 3:36pm UTC](https://community.glideapps.com/t/glide-isnt-showing-data-as-a-percentage-when-it-is-in-google-sheet/47740/2 "2022-08-25T15:36:41Z")

</div>

Glide syncs data from your Google Spreadsheet.  
Glide does _not_ sync formatting from your Google Sheet.  
If you were to reformat the column in your Google Sheet as a number, you would see that the underlying values are actually decimal numbers. And this is what Glide sees.

To display them as percentages in Glide, what you can do is use a Math column to multiply the number by 100, and add the percent sign as a display unit.

 ![Screen Shot 2022-08-25 at 11.33.36 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/9/d960c75d00cf8db15f94f3135e4f90006b195706.png)

---

<div class="post-metadata">

### Author: ![EricDolence](https://avatars.discourse-cdn.com/v4/letter/e/8e7dd6/32.png) [@EricDolence](https://community.glideapps.com/u/EricDolence)
#### Post date: [August 25, 2022, 3:47pm UTC](https://community.glideapps.com/t/glide-isnt-showing-data-as-a-percentage-when-it-is-in-google-sheet/47740/3 "2022-08-25T15:47:19Z")

</div>

Interesting…that makes sense. But I have done the same exact thing with two apps I previously made, and the percentages came through no problem without having to do a math column. I’ll do a little more digging. Thank you Darren!