# Number formatting does not pass over into IF THEN columns

**URL:** <https://community.glideapps.com/t/number-formatting-does-not-pass-over-into-if-then-columns/15436>\
**Category:** Report a Bug\
**Created:** [September 8, 2020, 2:53am UTC](https://community.glideapps.com/t/number-formatting-does-not-pass-over-into-if-then-columns/15436 "2020-09-08T02:53:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\
**Post date:** [September 8, 2020, 2:53am UTC](https://community.glideapps.com/t/number-formatting-does-not-pass-over-into-if-then-columns/15436/1 "2020-09-08T02:53:31Z")

</div>

When I create an IF THEN column and add number columns as the output, the formatting for decimals is lost. See below.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/db50aef5acc31eef7faf07549700199adbc22f78.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/aa47b65ac8d116b73d049dc1d57e80a0647ec998.png)

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [September 8, 2020, 3:08am UTC](https://community.glideapps.com/t/number-formatting-does-not-pass-over-into-if-then-columns/15436/2 "2020-09-08T03:08:34Z")

</div>

THANK YOU FOR BLURRING PERSONAL DETAILS! 😍

---

<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 8, 2020, 4:00am UTC](https://community.glideapps.com/t/number-formatting-does-not-pass-over-into-if-then-columns/15436/3 "2020-09-08T04:00:42Z")

</div>

Create a template of the number column and use that for the IF/THEN.

---

<div class="post-metadata">

**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\
**Post date:** [September 8, 2020, 5:41am UTC](https://community.glideapps.com/t/number-formatting-does-not-pass-over-into-if-then-columns/15436/4 "2020-09-08T05:41:15Z")

</div>

Clickup chrome add-on is the best! 🤟🏽

---

<div class="post-metadata">

**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\
**Post date:** [September 8, 2020, 5:41am UTC](https://community.glideapps.com/t/number-formatting-does-not-pass-over-into-if-then-columns/15436/5 "2020-09-08T05:41:46Z")

</div>

Great workaround as always! Thanks Jeff.