# How to set up full local currency?

**URL:** <https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804>\
**Category:** Ask for Help\
**Created:** [May 16, 2023, 7:19am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804 "2023-05-16T07:19:54Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [May 16, 2023, 7:19am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/1 "2023-05-16T07:19:54Z")

</div>

Hi Gliders,

I use Glide tables and would like to set up the numbers with full local currency, not only currency symbol. For IDR/Indonesian Rupiah, the numbers use point as group separator, not comma (orange box on an image below). My client insist to use the right format of our local currency.

Does anyone know how to set up the numbers? Thanks in advance.

 ![Screenshot 2023-05-16 140146](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d2cbbf34c7e865f03b42a6124a6e70dbed61ca68.jpeg)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [May 16, 2023, 7:27am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/2 "2023-05-16T07:27:03Z")

</div>

You can use JavaScript to convert the number to local

---

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [May 16, 2023, 7:50am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/3 "2023-05-16T07:50:22Z")

</div>

JavaScript?! Oh, no… I’m just a no-code developer… 😀

Thanks for your quick response @Uzo 🙏

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [May 16, 2023, 8:27am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/4 "2023-05-16T08:27:02Z")

</div>

a little bit of Java will not hurt you 😉

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [May 16, 2023, 9:10am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/5 "2023-05-16T09:10:37Z")

</div>

```auto
if(p1){
let rupee = new Intl.NumberFormat('en-IN', {
    style: 'currency',
    currency: 'INR',
});
var price = p1;
return('Rupees: ' + rupee.format(price));
}

```

---

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [May 16, 2023, 9:21am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/6 "2023-05-16T09:21:58Z")

</div>

Thanks @Uzo… Do I use this JavaScript on Code column?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [May 16, 2023, 9:23am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/7 "2023-05-16T09:23:00Z")

</div>

yes… JavaScript column… put your price as p1 variable

 ![Screen Shot 2023-05-15 at 11.23.34 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/12b89016d9fc64423cd9654693c37d68607a3cf2.png)

you can take out 'Rupees: ’ +  
from return if you want just price

---

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [May 16, 2023, 9:38am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/8 "2023-05-16T09:38:43Z")

</div>

I’m using Indonesian Rupiah, not Indian Rupee. But, it’s done and thanks again @Uzo 👍 👍

 ![Screenshot 2023-05-16 163632](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b9754b6a1a6960ff1f5122d480fac7b970f2252.png)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [May 16, 2023, 9:41am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/9 "2023-05-16T09:41:24Z")

</div>

I hope you will start loving Java 😉

---

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [May 16, 2023, 9:47am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/10 "2023-05-16T09:47:45Z")

</div>

I hope so. Actually, I just copied and made a little modification only 😀 👌

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 17, 2023, 9:47am UTC](https://community.glideapps.com/t/how-to-set-up-full-local-currency/61804/11 "2023-05-17T09:47:53Z")

</div>

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