Numerical format in Spanish.

[JSO]

I have 2 applications in AppSheet, one is a copy of the other.
In principle I think they are both exactly the same.
However, today I find that they use a different numerical format (until now they were the same).
I have seen that they have corrected something because sometimes it did not put the decimal separator and now it does (although different formats in each application).
Checked the Sheet tables and the definition in ApPSheet, both are in Spanish.
Does anyone know anything about why this happens?

App 1: Correct Spanish numerical format

App 2: Incorrect Spanish numeric format

[Suvrutt_Gurjar]

in case of the second app , where it is displaying incorrect Spanish numeric format, if you are using Google sheet as backend sheet, please try setting all the columns or at least the "Cobrar"  to "Plain Text"

BTW I have requested community moderator to move this post to "Q&A" section.

[JSO]

Thanks for the suggestion.
The result I get when I change it to Plain Text is even worse. It not only loses the format but also the meaning.
It doesn't seem like a good option.

It's also doing something strange to me:
If I edit a data with which this is calculated, the final calculated result is correct (I save it in the Sheet) but it is presented multiplied by 100.
I think it is a problem that my application does not pay attention to the Sheet Location format.

That doesn't happen if I put it back in numerical format (although it still shows the semicolon changed)

[Suvrutt_Gurjar]

Sorry, my bad. I performed some more testing. In the numerical format, could you please try the below setting for the price type column.

With this setting, the backend looks like below (price column)

And the app view also shows the format correctly as shown below. 

My Google chrome browser language was set to Spanish, the AppSheet table settings were also set to Spanish locale

Finally the locale of the Google sheet is also Spanish as shown below

Hope this helps.

[JSO]

Add the € symbol but keep the semicolon and semicolon inverted.

[Suvrutt_Gurjar]

Okay, thank you for the update. Hope you have set the Google sheet column setting for price column as suggested earlier.

If it is still causing a problem, then I  am afraid I have nothing more to suggest because with those settings it is working for me.

Someone else may have suggestion or you may contact support.

[JSO]

The curious thing is that I work in parallel with two applications (they use different data) and except for an error that I am not aware of, I have them configured in the same way and they behave differently in terms of numerical presentation.

[AleksiAlkio · Accepted solution]

If the data source and the app have the same and proper locale settings, the format should come from your default browser's language settings. With the Chrome, the preferred language needs to be on the top of that list. It's not enough if it's the 2nd one or later 

[JSO]

That is the reason.
This is how the browser had.

Apparently the Latin American format was taking over.
Thank you so much.

[AleksiAlkio]

Good to hear!