# Number Formatting DocsAutomator

**URL:** <https://community.glideapps.com/t/number-formatting-docsautomator/63643>\
**Category:** Ask for Help\
**Created:** [July 7, 2023, 4:39pm UTC](https://community.glideapps.com/t/number-formatting-docsautomator/63643 "2023-07-07T16:39:43Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Curtis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curtis/32/59826_2.png) [@Curtis](https://community.glideapps.com/u/Curtis)\
**Post date:** [July 7, 2023, 4:39pm UTC](https://community.glideapps.com/t/number-formatting-docsautomator/63643/1 "2023-07-07T16:39:43Z")

</div>

When using DocsAutomator to generate PDF’s and using math columns as field inputs it is not respecting the decimal precision or the units selected. It passes the math column result without the defined formatting.

For example £104.00 becomes 104.003721

Is there a similar problem with PDF Monkey?

---

<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:** [July 7, 2023, 4:57pm UTC](https://community.glideapps.com/t/number-formatting-docsautomator/63643/2 "2023-07-07T16:57:29Z")

</div>

Instead of relying on the precision function to handle your rounding, use the round function in your math.

`ROUND(X, 2)`

See if that helps.  
The problem with only setting the precision is that it’s cosmetic and doesn’t actually round the underlying value. It only rounds for display purposes. When you use the Round math function, the result is truly rounded.

---

<div class="post-metadata">

**Author:** ![Rupert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rupert/32/44178_2.png) [@Rupert](https://community.glideapps.com/u/Rupert)\
**Post date:** [July 11, 2023, 4:11pm UTC](https://community.glideapps.com/t/number-formatting-docsautomator/63643/3 "2023-07-11T16:11:33Z")

</div>

@Curtis Let me know if you need help with automating documents using DocsAutomator! Always happy to support 🙂

---

<div class="post-metadata">

**Author:** ![Curtis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curtis/32/59826_2.png) [@Curtis](https://community.glideapps.com/u/Curtis)\
**Post date:** [July 11, 2023, 4:29pm UTC](https://community.glideapps.com/t/number-formatting-docsautomator/63643/4 "2023-07-11T16:29:12Z")

</div>

Thanks Rupert,  
We’re just getting setup and evaluating options.  
Is DocsAutomator able to handle line items yet? I know you mentioned it in an older YT Video.

---

<div class="post-metadata">

**Author:** ![Rupert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rupert/32/44178_2.png) [@Rupert](https://community.glideapps.com/u/Rupert)\
**Post date:** [July 11, 2023, 4:43pm UTC](https://community.glideapps.com/t/number-formatting-docsautomator/63643/5 "2023-07-11T16:43:01Z")

</div>

DocsAutomator is able to handle line items, but the Glide integration is not currently. You would have to use a workaround with Make, Zapier, … happy to help with that, but I also published a video about it here:  
[https://youtu.be/pbIaLZGk-LQ](https://youtu.be/pbIaLZGk-LQ)

---

<div class="post-metadata">

**Author:** ![shragat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shragat/32/83418_2.png) [@shragat](https://community.glideapps.com/u/shragat)\
**Post date:** [November 26, 2025, 4:52am UTC](https://community.glideapps.com/t/number-formatting-docsautomator/63643/6 "2025-11-26T04:52:15Z")

</div>

Hi

Can you elaborate on that. Im not sure how to add rounding on the math column.

Thanks

---

<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 26, 2025, 5:36am UTC](https://community.glideapps.com/t/number-formatting-docsautomator/63643/7 "2025-11-26T05:36:02Z")

</div>

The math formula is in my post. ‘ROUND’ is the rounding function. ‘X’ is the value you would replace with the column that contains the number you want to round. ‘2’ is the number of decimal places you want to round to.
