# Leading Zeros

**URL:** <https://community.glideapps.com/t/leading-zeros/19932>\
**Category:** Ask for Help\
**Created:** [December 16, 2020, 1:39am UTC](https://community.glideapps.com/t/leading-zeros/19932 "2020-12-16T01:39:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\
**Post date:** [December 16, 2020, 1:39am UTC](https://community.glideapps.com/t/leading-zeros/19932/1 "2020-12-16T01:39:20Z")

</div>

Hi,  
I did not find solution for leading zeros in the forum.

My use case, I need leading zeros to be accepted as they are because it is for mobile number.

What will be the best automated way? I know you can manually go in and put '0 infront. I have also formatted as plain text. But when new row is added, this plain text formatting is gone.

Suggestions please.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [December 16, 2020, 1:42am UTC](https://community.glideapps.com/t/leading-zeros/19932/2 "2020-12-16T01:42:23Z")

</div>

Do you need the column to be a number field inside Glide? If not, you can change the column type from number to text and it _should_ respect the plain text formatting you set up in your sheet.

---

<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:** [December 16, 2020, 1:50am UTC](https://community.glideapps.com/t/leading-zeros/19932/3 "2020-12-16T01:50:12Z")

</div>

Have you tried using a phone entry and format your column as phone number?