I get dd.mm.yyyy instead of dd/mm/yyyy

[Rani_M]

Hey there,

In recent days, every time a date is entered in my apps, it's saved in GOOGLE SHEETS as dd.mm.yyyy instead of dd/mm/yyyy. This issue occurs when I use several mobile phones and PC, even after playing with local settings. I even tried using the TEXT formula to force the necessary format.

Appsheet recognizes it as a date, but Google Sheets does not. Do you have any idea what might be causing this and how to fix it?

[AleksiAlkio · Accepted solution]

What locales are you using? I checked one of my old apps that is using gSheet, and it has recorded dates with dots from 2017 with Finnish locale settings.