# Separate the decimal number

**URL:** <https://community.glideapps.com/t/separate-the-decimal-number/16563>\
**Category:** Ask for Help\
**Created:** [September 30, 2020, 12:46pm UTC](https://community.glideapps.com/t/separate-the-decimal-number/16563 "2020-09-30T12:46:31Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [September 30, 2020, 1:23pm UTC](https://community.glideapps.com/t/separate-the-decimal-number/16563/5 "2020-09-30T13:23:32Z")

</div>

Check out this thread.

> [@TRUNC function in Math column or send results to sheet?](https://community.glideapps.com/t/trunc-function-in-math-column-or-send-results-to-sheet/14863/5):
>
> Check out the concept I made here in the Trunc test tab. What I did behind the scenes, assuming Dave only needs positive numbers as inputs. A math column & template column to round the number up to integer. A delta column = number - integer temp. The helper column is 1 + delta column. Final value: If delta less than 0 then helper, if delta equals 0 then 0, else delta.

---

_[View the full topic](https://community.glideapps.com/t/separate-the-decimal-number/16563)._