# Numbers column forcing 001

**URL:** <https://community.glideapps.com/t/numbers-column-forcing-001/69446>\
**Category:** Ask for Help\
**Created:** [January 10, 2024, 2:23pm UTC](https://community.glideapps.com/t/numbers-column-forcing-001/69446 "2024-01-10T14:23:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\
**Post date:** [January 10, 2024, 2:23pm UTC](https://community.glideapps.com/t/numbers-column-forcing-001/69446/1 "2024-01-10T14:23:41Z")

</div>

Hi, I would like to be able to use a number column but set the column so that the number 1 actually reads 001 etc.

Is this possible?  
Thanks

---

<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:** [January 10, 2024, 2:27pm UTC](https://community.glideapps.com/t/numbers-column-forcing-001/69446/2 "2024-01-10T14:27:25Z")

</div>

Not with the number column, no.

What you could do is use a Pad Text column to insert the extra zeros where necessary.  
The only thing is that would return a string, so if you needed to do any calculations with the number, you would need to use the original number column for those.

> **[Pad Text at Start column | Glide](https://www.glideapps.com/plugins/pad-start)**
>
> Pads string on the left side if it's shorter than length. Padding characters are truncated if they exceed length.

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [January 10, 2024, 2:29pm UTC](https://community.glideapps.com/t/numbers-column-forcing-001/69446/3 "2024-01-10T14:29:11Z")

</div>

I use this solution ☝🏼

---

<div class="post-metadata">

**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\
**Post date:** [January 10, 2024, 2:50pm UTC](https://community.glideapps.com/t/numbers-column-forcing-001/69446/4 "2024-01-10T14:50:42Z")

</div>

Great, this is perfect.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 10, 2024, 3:02pm UTC](https://community.glideapps.com/t/numbers-column-forcing-001/69446/5 "2024-01-10T15:02:10Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/c/dc1cc7e1abb632baf91f28a9600562948f9db341.png)

Here’s an alternative.

---

<div class="post-metadata">

**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\
**Post date:** [January 10, 2024, 3:15pm UTC](https://community.glideapps.com/t/numbers-column-forcing-001/69446/6 "2024-01-10T15:15:35Z")

</div>

thank you
