# Decimal point problem

**URL:** <https://community.glideapps.com/t/decimal-point-problem/1663>\
**Category:** Report a Bug\
**Created:** [November 4, 2019, 1:33pm UTC](https://community.glideapps.com/t/decimal-point-problem/1663 "2019-11-04T13:33:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sab\_Sabrina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sab_sabrina/32/1300_2.png) [@Sab\_Sabrina](https://community.glideapps.com/u/Sab_Sabrina)\
**Post date:** [November 4, 2019, 1:33pm UTC](https://community.glideapps.com/t/decimal-point-problem/1663/1 "2019-11-04T13:33:13Z")

</div>

Hi everyone,  
I got this problem in displaying 2 decimal points.  
This field is the result of this operation: =G23-F23

Already set 2 decimal points in excel sheet.  
Yet, still got this kind of error.

Do you have any idea?  
Really appreciate your help.

Thanks.

 ![05](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/46cf172f61bc606ea6b0fe1bf1e912c34eb99d23.jpeg)

---

<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 4, 2019, 2:06pm UTC](https://community.glideapps.com/t/decimal-point-problem/1663/2 "2019-11-04T14:06:47Z")

</div>

Do not use the sheet’s column formatting function. The sheets formatting is just so it looks nice in the spreadsheet. The underlying data is still the same. Either create a new column that copies the value from the original column, or since you are already using a formula in your sheet, replace it with this. `=TEXT(G23-F23, "###0.00")`

---

<div class="post-metadata">

**Author:** ![Sab\_Sabrina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sab_sabrina/32/1300_2.png) [@Sab\_Sabrina](https://community.glideapps.com/u/Sab_Sabrina)\
**Post date:** [November 5, 2019, 2:03am UTC](https://community.glideapps.com/t/decimal-point-problem/1663/3 "2019-11-05T02:03:33Z")

</div>

Thanks Jeff!  
Problem solved by using your recommendation as above.  
😉😉😉

---

<div class="post-metadata">

**Author:** ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)\
**Post date:** [November 22, 2019, 8:24pm UTC](https://community.glideapps.com/t/decimal-point-problem/1663/4 "2019-11-22T20:24:19Z")

</div>

That works fine if you are working in sheets but what if you are using the Math calcs in Data? I have the same issue and it just looks strange.

---

<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 23, 2019, 3:04pm UTC](https://community.glideapps.com/t/decimal-point-problem/1663/5 "2019-11-23T15:04:38Z")

</div>

The current math function doesn’t allow us to specify the number of decimal places right now. I’m sure they will expand the math capabilities in the future.