# How to fix the number to 2 decimal points

**URL:** <https://forum.adalo.com/t/how-to-fix-the-number-to-2-decimal-points/14562>\
**Category:** Database\
**Created:** [July 6, 2021, 8:25am UTC](https://forum.adalo.com/t/how-to-fix-the-number-to-2-decimal-points/14562 "2021-07-06T08:25:42Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kalskee](https://avatars.discourse-cdn.com/v4/letter/k/8e8cbc/32.png) [@kalskee](https://forum.adalo.com/u/kalskee)\
**Post date:** [July 6, 2021, 8:25am UTC](https://forum.adalo.com/t/how-to-fix-the-number-to-2-decimal-points/14562/1 "2021-07-06T08:25:43Z")

</div>

hi all. how can i fix the number to 2 decimal points. for example 10.70

everytime i want to to set to 10.70 , the system will store as 10.7

the only time i can make it 10.70 is when i set it to currency format.

can anyone help me with this?

I tried INT( x100)/100 and ABS( x 100)/100 but it still shows 10.7

---

<div class="post-metadata">

**Author:** ![kalskee](https://avatars.discourse-cdn.com/v4/letter/k/8e8cbc/32.png) [@kalskee](https://forum.adalo.com/u/kalskee)\
**Post date:** [July 6, 2021, 11:00am UTC](https://forum.adalo.com/t/how-to-fix-the-number-to-2-decimal-points/14562/2 "2021-07-06T11:00:49Z")

</div>

any can help me please?

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [July 6, 2021, 11:08am UTC](https://forum.adalo.com/t/how-to-fix-the-number-to-2-decimal-points/14562/3 "2021-07-06T11:08:48Z")

</div>

Hi @kalskee,

Unfortunately, number formatting built in Adalo doesn’t allow such capability.  
Possible workaround could be to split the number into two - integer and fraction, and display them separately. I know it’s not the best solution (especially it requires additional property in a collection and some operations).

Best regards, Victor.

---

<div class="post-metadata">

**Author:** ![kalskee](https://avatars.discourse-cdn.com/v4/letter/k/8e8cbc/32.png) [@kalskee](https://forum.adalo.com/u/kalskee)\
**Post date:** [July 6, 2021, 11:48am UTC](https://forum.adalo.com/t/how-to-fix-the-number-to-2-decimal-points/14562/4 "2021-07-06T11:48:37Z")

</div>

do you mind giving me the formula example to split them.

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [July 6, 2021, 12:27pm UTC](https://forum.adalo.com/t/how-to-fix-the-number-to-2-decimal-points/14562/5 "2021-07-06T12:27:20Z")

</div>

Hi @kalskee,

Let’s call the variables: TOTAL (the number itself), INTEGER (integer part) and FRACTION (fractional part).

INTEGER = INT (TOTAL)

FRACTION = INT ( ( TOTAL - INT (TOTAL) ) \* 100 )

With this you get, let’s take the number 123,45678:

INTEGER = INT (123,45678) = 123

FRACTION = INT ( ( 123,45678 - INT (123,45678) ) \* 100 ) = INT ( ( 123,45678 - 123 ) \* 100 ) = INT ( 0, 45678 \* 100) = 45.

Of course need to check this in the app )))

Best,  
Victor.

---

<div class="post-metadata">

**Author:** ![kalskee](https://avatars.discourse-cdn.com/v4/letter/k/8e8cbc/32.png) [@kalskee](https://forum.adalo.com/u/kalskee)\
**Post date:** [July 6, 2021, 12:35pm UTC](https://forum.adalo.com/t/how-to-fix-the-number-to-2-decimal-points/14562/6 "2021-07-06T12:35:07Z")

</div>

tq for the response! you’re the best
