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
#2 after the separator = interpreted as text
#3 after the separator = interpreted as a number without the point.
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.