# 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:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JAS\_LANGKAWI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jas_langkawi/32/13_2.png) [@JAS\_LANGKAWI](https://community.glideapps.com/u/JAS_LANGKAWI)\
**Post date:** [September 30, 2020, 12:46pm UTC](https://community.glideapps.com/t/separate-the-decimal-number/16563/1 "2020-09-30T12:46:31Z")

</div>

Hi. Is there a way to separate the decimal number.

example :

Number Column 1 Column 2  
6.7877 6 0.7877

- using add glide column function. Not using spreadsheet function

Thanks.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [September 30, 2020, 1:00pm UTC](https://community.glideapps.com/t/separate-the-decimal-number/16563/2 "2020-09-30T13:00:47Z")

</div>

1. Create a math column to set the precision to 1. (6.7877 -\> 6)
2. Create a template column and replace any letter with that math column (this converts the number to a string: 6 -\> “6” )
3. Create a math column to subtract the string column from the original column (6.7877 - “6” = 0.7877)

---

<div class="post-metadata">

**Author:** ![JAS\_LANGKAWI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jas_langkawi/32/13_2.png) [@JAS\_LANGKAWI](https://community.glideapps.com/u/JAS_LANGKAWI)\
**Post date:** [September 30, 2020, 1:04pm UTC](https://community.glideapps.com/t/separate-the-decimal-number/16563/3 "2020-09-30T13:04:21Z")

</div>

I try this, but i don’t get 6 but I get 7

---

<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.

---

<div class="post-metadata">

**Author:** ![JAS\_LANGKAWI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jas_langkawi/32/13_2.png) [@JAS\_LANGKAWI](https://community.glideapps.com/u/JAS_LANGKAWI)\
**Post date:** [September 30, 2020, 1:25pm UTC](https://community.glideapps.com/t/separate-the-decimal-number/16563/6 "2020-09-30T13:25:18Z")

</div>

thanks. I get it now.