Created attachment 119233 [details]
screenshot of a completely unformatted spreadheet with locale settings
or do it right. See attached screen shot.
You’re not describing what’s the issue you’re having.
The screeshot demonstrates clearly that I've set up a date acceptance pattern which includes D/Y, opened a blank, new, unformatted document and entered a valid date expression 6/7 which was not accepted. Instead I get the text 6/7.
The only way to enter a date
Created attachment 119390 [details]
Spreadsheet demonstrating dysfunctional date input
Never mind. For the records only.