# Form number input decimal separator **URL:** \ **Category:** Ask for Help\ **Created:** [April 4, 2023, 6:53pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148 "2023-04-04T18:53:49Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Spiro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spiro/32/57073_2.png) [@Spiro](https://community.glideapps.com/u/Spiro)\ **Post date:** [April 4, 2023, 6:53pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/1 "2023-04-04T18:53:49Z")
Hi, My g.sheets locale is correctly set, but when I try to input a decimal number in Glide app it only allows a dot, and not a comma. My locale uses comma, and sheets displays a comma as well. If I try to use comma in Glide input field, nothing gets passed to sheets, dot works, and it gets passed as comma to sheets. Also in Glide data sources I see a comma if I did not edit the column, but as soon as I edit it (add units for example) I get dots instead of a comma. Any advice is appreciated. Tnx. ---
**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:** [April 4, 2023, 7:18pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/2 "2023-04-04T19:18:44Z")
Is the Locale for your browser and OS set correctly? ---
**Author:** ![Spiro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spiro/32/57073_2.png) [@Spiro](https://community.glideapps.com/u/Spiro)\ **Post date:** [April 4, 2023, 7:34pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/3 "2023-04-04T19:34:57Z")
Language in FF is set to GB, there is no locale option. Locale in sheets is set to Croatian, and the language in Android is set to US, but the region is Croatia. Everything else works as expected. ---
**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:** [April 4, 2023, 7:37pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/4 "2023-04-04T19:37:52Z")
I’ve seen 3 posts in the past few days regarding the locale for numbers, so I’m starting to wonder if there is a bug somewhere. It should be automatic based on your system settings. ---
**Author:** ![Spiro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spiro/32/57073_2.png) [@Spiro](https://community.glideapps.com/u/Spiro)\ **Post date:** [April 4, 2023, 7:37pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/5 "2023-04-04T19:37:58Z")
This is for both Windows and android. The behavior is the same. ---
**Author:** ![Spiro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spiro/32/57073_2.png) [@Spiro](https://community.glideapps.com/u/Spiro)\ **Post date:** [April 4, 2023, 7:39pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/6 "2023-04-04T19:39:26Z")
Hi Jeff, tnx for the reply. If you work for Glide and need to me to troubleshoot anything do let me know. Can’t today, way to exhausted, but I can try tomorrow. ---
**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:** [April 4, 2023, 8:01pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/7 "2023-04-04T20:01:20Z")
I do not work for Glide, but you can try submitting a support ticket. > [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2): > > Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link: ---
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 4, 2023, 8:16pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/8 "2023-04-04T20:16:08Z")
hi @Spiro, maybe this helps. i assume it’s not a bug, it’s only that glide uses the US locale and this doesn’t seem to adjust in browser. I got this hint from a glider today: > [@Really no solution for thousand separator?](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/15): > > There is no control over this chart values look. Hope this helps. ---
**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:** [April 4, 2023, 8:31pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/9 "2023-04-04T20:31:01Z")
You should not have to do any special javascript to get the number formatted the way you want. Glide should be handling this depending on your locale. While the javascript solution may work, I don’t believe it should be necessary. Glide has been handling the decimal and thousands separator correctly for several years. Only recently, does it appear to be an issue. The locale is determined by the device, and the app should adapt accordingly. If everything is working correctly, we can both view the same app and I will see numbers in US format, whereas you will see them in German format. Glide is designed to automatically handle different number formats, as well as automatic translation of certain components. The experience for each user should be unique to their device settings. ---
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 4, 2023, 8:44pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/10 "2023-04-04T20:44:19Z")
Interesting. As far as i remember Airtable had always problems with that topic. So, we should then open a ticket for that. ---
**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:** [April 4, 2023, 9:03pm UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/11 "2023-04-04T21:03:51Z")
I would recommend a ticket, unless others from your region can chime in. I tried it just now, and when I change the default language of my browser to German, it changes how it’s viewed in the table. OS Region setting didn’t seem to make a difference, but the browser definitely did. Browser language set to English: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/c/dc0d47316701957dbe1fe08c93d52277d939493c.png) Browser language set to German: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f27430a51812f3272fc5034300acfa89e90b8061.png) I didn’t have to do anything special other than make sure my browser is set correctly…so for me it’s working as expected. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/429e333422ef1d031dadbc84c304d7de2b9b298e.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 5, 2023, 12:57am UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/12 "2023-04-05T00:57:39Z")
> [@Jeff\_Hager](#): > > I would recommend a ticket, unless others from your region can chime in. I tried it just now, and when I change the default language of my browser to German, it changes how it’s viewed in the table. OS Region setting didn’t seem to make a difference, but the browser definitely did. I can confirm this. ---
**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:** [April 5, 2023, 2:15am UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/13 "2023-04-05T02:15:22Z")
Also, please remember that the Glide number entry will accept any character in iOS Safari, be aware of that. Multiple users, including me, have reported this severe bug, but Glide does not care to answer for years. Doing some crucial Apps, like accounting or inventory management, might cost you fundamental errors, and it is hard to find if you have extensive data. I would recommend fixing the entry to the number using JavaScript or creating a warning and rejection algorithm. ---
**Author:** ![Spiro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spiro/32/57073_2.png) [@Spiro](https://community.glideapps.com/u/Spiro)\ **Post date:** [April 5, 2023, 6:19am UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/14 "2023-04-05T06:19:02Z")
Hi all, tnx for the replies. I can confirm that changing the language of my BROWSER does change the behavior. OS region does not affect the app. This does not seem right to me. I want my browser in English (and my OS), but my locale (region) in Croatian. This works perfectly with other apps/pages. Also what is strange is that when my app DISPLAYS the numbers, they are formatted correctly. Only on the input field of the form it accepts what is set by the language of the browser. Is there any way to change this? ---
**Author:** ![Spiro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spiro/32/57073_2.png) [@Spiro](https://community.glideapps.com/u/Spiro)\ **Post date:** [April 5, 2023, 6:57am UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/15 "2023-04-05T06:57:20Z")
Another thing I just noticed. Even if I change my browser language all my data sources are still “stuck” with a dot instead of a comma, and in the app data is displayed sometimes with a comma, and sometimes with a dot. This looks more and more like a bug. ---
**Author:** ![Spiro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spiro/32/57073_2.png) [@Spiro](https://community.glideapps.com/u/Spiro)\ **Post date:** [April 5, 2023, 7:38am UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/16 "2023-04-05T07:38:18Z")
…and I can’t open a support ticket as I just get sent to a page with a bot that gives me wrong info and when I ask to open a support ticket it redirects me back to itself…frustrating. This is with browser set to Croatian, and trying to edit in Data sources. Data is displayed with a dot and upon edit it is with a comma. And app displays comma for some fields, and dot for others: ![Screenshot 2023-04-05 093747](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/81cf0d60a2f1a8a6278cb48b8ea938097ed09249.png) ---
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 5, 2023, 8:33am UTC](https://community.glideapps.com/t/form-number-input-decimal-separator/60148/17 "2023-04-05T08:33:01Z")
Oh… for years. Doesn’t sound good. Maybe @Jeff_Hager, you as an expert and a really helpful ressource for glide AND new users get any response from them? BTW: You are the reason, why i kept on working with this tool although is not that intuitive like Softr and Co.