0

With locale set to Brazil (number format is 24.999,75 and date is 20/5/2017) typing a number with a point separator (.) results in different interpretations depending on the number digits after the point:

#1 after the separator = interpreted as a date
enter image description here

#2 after the separator = interpreted as text
enter image description here

#3 after the separator = interpreted as a number without the point.
enter image description here

Are there any work arounds for this? I tried lots of locales and all of them present the same or analog behaviour. I fear users will eventually make a mistake inside my sheet typing a point instead of a comma and I'll have to track it down in the future.

Improve this question
1
  • 1
    Welcome to Web Applications. What is the purspose of writting a number with a dot when using Brazil as the regional setting?
    – Rubén ♦
    Oct 12, 2020 at 4:42

1 Answer 1

Reset to default
0

You could use Data > Data Validation and set the cell to accept only valid dates (using your own textual help for users) refusing and invalid entry.

enter image description here

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.