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.

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

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

2
  • Actually I need it not to be a date. 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.