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
  • 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
2
  • Actually I need it not to be a date.
    – Rodrigo Seiji
    Oct 13, 2020 at 20:17
  • Same answer then... just select Number under Data Validation...
    – 24601
    Oct 13, 2020 at 20:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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