# Truncate number

**URL:** <https://community.parabola.io/t/truncate-number/693>\
**Category:** Ask a question\
**Created:** [June 14, 2020, 1:37pm UTC](https://community.parabola.io/t/truncate-number/693 "2020-06-14T13:37:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Steve\_Marquis](https://avatars.discourse-cdn.com/v4/letter/s/bc79bd/32.png) [@Steve\_Marquis](https://community.parabola.io/u/Steve_Marquis)\
**Post date:** [June 14, 2020, 1:37pm UTC](https://community.parabola.io/t/truncate-number/693/1 "2020-06-14T13:37:10Z")

</div>

Can I truncate a number? I am doing an age calculation and want to truncate the result. I did a number format (0 decimal places) but that seems to round up. For age, I don’t want to round up.

Thanks, Steve

---

<div class="post-metadata">

**Author:** ![andrew](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/andrew/32/36_2.png) [@andrew](https://community.parabola.io/u/andrew)\
**Post date:** [June 15, 2020, 6:00am UTC](https://community.parabola.io/t/truncate-number/693/2 "2020-06-15T06:00:22Z")

</div>

@Steve_Marquis – there might be a better way to do this, but you should be able to use the `Text Extract` step to solve this. You’ll want to find all text before the `.`. See below!

 ![Screenshot 2020-06-14 22.59.08](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/f5c5011347019054428285f88a604d4cfdf72f24.png)

---

<div class="post-metadata">

**Author:** ![Steve\_Marquis](https://avatars.discourse-cdn.com/v4/letter/s/bc79bd/32.png) [@Steve\_Marquis](https://community.parabola.io/u/Steve_Marquis)\
**Post date:** [June 16, 2020, 1:30am UTC](https://community.parabola.io/t/truncate-number/693/3 "2020-06-16T01:30:38Z")

</div>

That works. Thanks Andrew.

---

<div class="post-metadata">

**Author:** ![andrew](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/andrew/32/36_2.png) [@andrew](https://community.parabola.io/u/andrew)\
**Post date:** [June 16, 2020, 2:05am UTC](https://community.parabola.io/t/truncate-number/693/4 "2020-06-16T02:05:01Z")

</div>

Awesome, glad to hear it!
