# Tranform a text column to a number column

**URL:** <https://community.glideapps.com/t/tranform-a-text-column-to-a-number-column/61448>\
**Category:** Ask for Help\
**Created:** [May 7, 2023, 3:37pm UTC](https://community.glideapps.com/t/tranform-a-text-column-to-a-number-column/61448 "2023-05-07T15:37:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\
**Post date:** [May 7, 2023, 3:37pm UTC](https://community.glideapps.com/t/tranform-a-text-column-to-a-number-column/61448/1 "2023-05-07T15:37:03Z")

</div>

Hi every body,

Any chance to transform a text column with a number extracted from a split text to a number column so it’s possible to apply diferent rollup formules afterwards?

Thanks in advanced;)!

Albert Puig

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 7, 2023, 4:16pm UTC](https://community.glideapps.com/t/tranform-a-text-column-to-a-number-column/61448/2 "2023-05-07T16:16:05Z")

</div>

Try using a math column, and multiply it by 1.

---

<div class="post-metadata">

**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\
**Post date:** [May 7, 2023, 5:52pm UTC](https://community.glideapps.com/t/tranform-a-text-column-to-a-number-column/61448/3 "2023-05-07T17:52:46Z")

</div>

Perfect, it worked ;)!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 8, 2023, 5:53pm UTC](https://community.glideapps.com/t/tranform-a-text-column-to-a-number-column/61448/4 "2023-05-08T17:53:34Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.