# Decimal point changes to a comma

**URL:** <https://community.glideapps.com/t/decimal-point-changes-to-a-comma/73152>\
**Category:** Ask for Help\
**Created:** [May 7, 2024, 1:40pm UTC](https://community.glideapps.com/t/decimal-point-changes-to-a-comma/73152 "2024-05-07T13:40:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![heidikruger](https://avatars.discourse-cdn.com/v4/letter/h/c37758/32.png) [@heidikruger](https://community.glideapps.com/u/heidikruger)\
**Post date:** [May 7, 2024, 1:40pm UTC](https://community.glideapps.com/t/decimal-point-changes-to-a-comma/73152/1 "2024-05-07T13:40:44Z")

</div>

I have a Random Number column with Precision set to 1.0000.  
I then use a Split Text column to split the Random Number using Split by = . (full stop)  
The problem I have is that every now and again, the Glide table seems to change the Random Number value to a comma. I.e the column value will change from 0.5088 to 0,5088.

The first time this happened, I changed my Split Text column to use the comma instead of the full stop. But after a while it returned to the decimal point value and I had to change my Split Text column again.

Now it did the same thing and I am wondering if anyone else has experienced this. Is this a bug or some setting on my browser that is causing this?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 7, 2024, 1:43pm UTC](https://community.glideapps.com/t/decimal-point-changes-to-a-comma/73152/2 "2024-05-07T13:43:16Z")

</div>

That behaviour is based on individual device regional settings.

But I would take a step back and ask why the split?

What is the end goal?

There is probably a better way to get what you want.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [May 11, 2024, 8:24am UTC](https://community.glideapps.com/t/decimal-point-changes-to-a-comma/73152/3 "2024-05-11T08:24:11Z")

</div>

> [@Darren\_Murphy](#):
>
> What is the end goal?
> 
> There is probably a better way to get what you want.

You probably want to be using a math formula in a math column: round(), floor(), trunc(), ceiling().

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 11, 2024, 2:27pm UTC](https://community.glideapps.com/t/decimal-point-changes-to-a-comma/73152/4 "2024-05-11T14:27:50Z")

</div>

I’d probably just multiply it by 10000. Then you don’t have to worry about decimals.

---

<div class="post-metadata">

**Author:** ![heidikruger](https://avatars.discourse-cdn.com/v4/letter/h/c37758/32.png) [@heidikruger](https://community.glideapps.com/u/heidikruger)\
**Post date:** [May 20, 2024, 7:19am UTC](https://community.glideapps.com/t/decimal-point-changes-to-a-comma/73152/5 "2024-05-20T07:19:02Z")

</div>

Thank you everyone for your input and feedback. Apologies for only responding now. It has been a crazy time.