# How to convert Numeric values

**URL:** <https://community.thunkable.com/t/how-to-convert-numeric-values/2519844>\
**Category:** Questions about Thunkable X\
**Created:** [July 25, 2023, 4:58pm UTC](https://community.thunkable.com/t/how-to-convert-numeric-values/2519844 "2023-07-25T16:58:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\
**Post date:** [July 25, 2023, 4:58pm UTC](https://community.thunkable.com/t/how-to-convert-numeric-values/2519844/1 "2023-07-25T16:58:02Z")

</div>

I don’t know if it’s possible to display the total number of rows in a spreadsheet from 1,000 to 1k,3,500 to 3.5k and so on ???

Thanks

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [July 25, 2023, 5:29pm UTC](https://community.thunkable.com/t/how-to-convert-numeric-values/2519844/2 "2023-07-25T17:29:40Z")

</div>

Can you explain in more detail? I don’t know what you mean. Are you just wanting to convert a number such as 1000 to “1k”?

---

<div class="post-metadata">

**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\
**Post date:** [July 25, 2023, 5:49pm UTC](https://community.thunkable.com/t/how-to-convert-numeric-values/2519844/3 "2023-07-25T17:49:01Z")

</div>

Am working on a notepad app,the app will save total number of records save in the spreadsheet and then display it the app for all users to see…so in a case of multiple users whereby thousands of records exist  
I don’t want it to show long numbers,so I want thousands to be “K”

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [July 25, 2023, 6:12pm UTC](https://community.thunkable.com/t/how-to-convert-numeric-values/2519844/4 "2023-07-25T18:12:58Z")

</div>

You can set up blocks that say if number \> 999 then divide the number by 1000, round the result, and join “k” to it.

---

<div class="post-metadata">

**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\
**Post date:** [July 25, 2023, 6:16pm UTC](https://community.thunkable.com/t/how-to-convert-numeric-values/2519844/5 "2023-07-25T18:16:46Z")

</div>

Wawuu!!

You are awesome,it works

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [October 23, 2023, 6:17pm UTC](https://community.thunkable.com/t/how-to-convert-numeric-values/2519844/6 "2023-10-23T18:17:05Z")

</div>

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