# Format number in IF-THEN column

**URL:** <https://community.glideapps.com/t/format-number-in-if-then-column/66813>\
**Category:** Ask for Help\
**Created:** [October 6, 2023, 9:23pm UTC](https://community.glideapps.com/t/format-number-in-if-then-column/66813 "2023-10-06T21:23:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fluittsolutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fluittsolutions/32/30155_2.png) [@fluittsolutions](https://community.glideapps.com/u/fluittsolutions)\
**Post date:** [October 6, 2023, 9:23pm UTC](https://community.glideapps.com/t/format-number-in-if-then-column/66813/1 "2023-10-06T21:23:04Z")

</div>

Hi, Gliders,

I have a math column that I have formatted to $XX.XX. However, I also need that result elsewhere in an IF-THEN column. Is there a way to format the result of the IF-THEN column for the dollar sign and two decimal points?

Thanks,  
Mona

---

<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:** [October 6, 2023, 9:43pm UTC](https://community.glideapps.com/t/format-number-in-if-then-column/66813/2 "2023-10-06T21:43:22Z")

</div>

If you pass that math value through a template column, it should lock in the formatting.