# Decimal limit (in formula)

**URL:** <https://community.glideapps.com/t/decimal-limit-in-formula/17731>\
**Category:** Ask for Help\
**Created:** [October 29, 2020, 1:42pm UTC](https://community.glideapps.com/t/decimal-limit-in-formula/17731 "2020-10-29T13:42:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [October 29, 2020, 1:42pm UTC](https://community.glideapps.com/t/decimal-limit-in-formula/17731/1 "2020-10-29T13:42:34Z")

</div>

While combining various columns, I use formula … =(I1 & “: " & I2 & " (” & H2 & “)”)

Cell H2’s value is 8.17 but in the formula above it returns 8.1666666666667.  
Is there a way to limit the decimals to two?

---

<div class="post-metadata">

**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:** [October 29, 2020, 2:10pm UTC](https://community.glideapps.com/t/decimal-limit-in-formula/17731/2 "2020-10-29T14:10:41Z")

</div>

You can use a text formula to keep it to 2 decimals, or round them.

Alternatively you can do this inside glide with math and template columns.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [October 29, 2020, 2:39pm UTC](https://community.glideapps.com/t/decimal-limit-in-formula/17731/3 "2020-10-29T14:39:32Z")

</div>

Can you change the column type in Glide to be a number? If you can, you could then set the precision to 2 decimal places.

---

<div class="post-metadata">

**Author:** ![GRobbins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grobbins/32/3924_2.png) [@GRobbins](https://community.glideapps.com/u/GRobbins)\
**Post date:** [October 29, 2020, 3:07pm UTC](https://community.glideapps.com/t/decimal-limit-in-formula/17731/4 "2020-10-29T15:07:23Z")

</div>

Tried changing col to number rather than text and it did not work. Trying ThinhDinh’s template suggestion now. Thanks to both of you for your quick replies. The vast array of solutions in Glide is beyond me and I appreciate (and learn) from the equally vast array of knowledge within the forum. 🙂