Decimal point changes to a comma

Ask for Help
1

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?

2

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.

2 Likes
3

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

4

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

1 Like
5

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