# Number formatting

**URL:** <https://community.glideapps.com/t/number-formatting/30544>\
**Category:** Feature Requests\
**Created:** [August 16, 2021, 2:37pm UTC](https://community.glideapps.com/t/number-formatting/30544 "2021-08-16T14:37:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [August 16, 2021, 2:37pm UTC](https://community.glideapps.com/t/number-formatting/30544/1 "2021-08-16T14:37:59Z")

</div>

Hey people, something that would really be cool would be to allow to add formatting to the number, e.g. if over 1000 → 1K, 2K, etc, same with millions, 1M, 2M, etc. When you have very large amounts it would be great to have this option. I know it can be done with an ITE, but it’d be fantastic to have a native option

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 16, 2021, 2:50pm UTC](https://community.glideapps.com/t/number-formatting/30544/2 "2021-08-16T14:50:34Z")

</div>

I think you can do it using an Excel formula in YC as well (faster):

Read how many zeros (000/000000) has your value and then add the “k” or “MM”.

Buen día Pablo!