How to change the decimal separator to a comma?

Hi, its possible to change the number formatting ?
My form https://form.jotform.com/240806725900656 when submit to excel goes with "." to separate decimals , but google sheets doesnt recognize it as number. It should be used "," example

100.10 should be 100,10

Thanks

Hi Daniel,

Thanks for reaching out to Jotform Support. Are you referring to the Form Calculation widget field? If yes, you need to add a "commaSeparate()" function in the formula to comma separate the calculation result. Here's how to do that:

1. In Form Builder, select the Form Calculation widget field and click the Wand icon.
2. Click the Calculation section and click the Function icon.
3. Search for commaSeparate() and select it.
4. Next, enclose the existing formula with a parenthesis and click on Save.

Checkout the screencast below to see my result:

You can clone my demo form. We have a guide on How to Clone an Existing Form From a URL.

Reach out again if you have any other questions.

Hi Daniel,

Thanks for getting back to us. I moved your other question to a new thread and helped you with that here.

Let us know if there’s anything else we can do for you.

Hi, thanks for the response.

But I dont want comma separator for large numbers

I want to use comma to separe number like 50.12 instead of using dots. So it should be "50,12". The point here is that my excel sheet doesnt recognize dots

It's possible to separe nubers with comma instead of dot?

Hi Daniel,

Thanks for getting back to us. You can use the Masked Input widget. With this widget, you can change the Decimal Separator to a comma. Let me show you how to add it to your form:

1. In Form Builder, click on the Add Form element menu on the left.
2. Go to the Widgets tab and drag and drop the Masked Input widget.

Give it a try and let us know if you have any other questions.