define the separator (point instead of comma) for decimals when splitting coordinates

[mymymy]

I have an Excel on Sharepoint to save points. In this file I do have a "coords_lat_long" (latlong), a "lat" (LAT([coords_lat_long]) (decimal) and a "long" (LONG([coords_lat_long]) (decimal) column. When I save points, the coordinates in the "lat" and "long" column are written using a comma 42,567354 instead of a point 42.567354. The Apple language settings are defined to use points. Can I define that somewhere in Appsheet? I'm using Mac.

[WillowMobileSys · Accepted solution]

Because those functions return decimal values, they will follow the locale settings on the device and/or the browser where you are running the app.  Make sure the locale settings are set properly - in the app and in the browser.

I don't know the expectations of all locales, but maybe for you the Lat/Long always uses points while numeric values use commas? 

[mymymy]

Thanks for your answer. No, we're using points for numeric values. Probably somewhere it's the wrong setting. Though it's a pity that I can't define it in Appsheet for this column. Would make the following analysis easier...