# Sheet Different than Glide Data

**URL:** <https://community.glideapps.com/t/sheet-different-than-glide-data/2389>\
**Category:** Ask for Help\
**Created:** [November 25, 2019, 1:17pm UTC](https://community.glideapps.com/t/sheet-different-than-glide-data/2389 "2019-11-25T13:17:32Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\
**Post date:** [November 25, 2019, 1:17pm UTC](https://community.glideapps.com/t/sheet-different-than-glide-data/2389/1 "2019-11-25T13:17:32Z")

</div>

My google sheet has just basic numbers (sometimes ONE decimal) and a calculation column.

 ![googlesheetsnip](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9113c8d51b1a64f0874d404da15c4ed188cd0ea4.png)

So the calculation column should never have more than one decimal

But the DATA sheet (and the app) take it out a BUNCH of decimal places.

 ![glidedatasnip](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6d4c3ffa6798d481b7f9d096ab806060b38ae36f.png)

---

<div class="post-metadata">

**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:** [November 25, 2019, 10:58pm UTC](https://community.glideapps.com/t/sheet-different-than-glide-data/2389/2 "2019-11-25T22:58:19Z")

</div>

I’ve noticed that too and seen a couple of comments regarding that. I’m hoping the math column will eventually be expanded to include rounding functionality to a specified number of decimals.

---

<div class="post-metadata">

**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\
**Post date:** [November 26, 2019, 1:58am UTC](https://community.glideapps.com/t/sheet-different-than-glide-data/2389/3 "2019-11-26T01:58:36Z")

</div>

What I do not understand is that there is NO reason for the extra decimal points. We are only entering something like the beginning mileage is 811.8 and ending mileage is 818.1 and the difference is something like 6.3000000000018

Where is that coming from?

I could understand if there were decimals that long, and I was trying to round them, but these are just added for no reason - not even mathematically correct??

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [November 26, 2019, 4:54am UTC](https://community.glideapps.com/t/sheet-different-than-glide-data/2389/4 "2019-11-26T04:54:33Z")

</div>

Formatting floating point numbers [is hard](https://www.zverovich.net/2019/02/11/formatting-floating-point-numbers.html). Right now we’re just using the platforms default code for doing that, which apparently doesn’t always do a great job. Sorry. We’ll get around to fixing it.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [January 28, 2020, 9:42am UTC](https://community.glideapps.com/t/sheet-different-than-glide-data/2389/5 "2020-01-28T09:42:26Z")

</div>

> [@Jeff\_Hager](#):
>
> I’m hoping the math column will eventually be expanded to include rounding functionality to a specified number of decimals.

@Mark when can we get this?

/Ralf

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [January 28, 2020, 1:54pm UTC](https://community.glideapps.com/t/sheet-different-than-glide-data/2389/6 "2020-01-28T13:54:17Z")

</div>

We can’t give you a timeline yet, sorry.
