Date Format - Doesn't work when selected

Ask a how-to question
Hi, I am using cloud based Only Office and on the excel I am trying to format cells so they result in a date format when the content is entered and if the wrong information is selected (i.e text) then it shows an error message. I have selected number format and then the date I want but after I select it, I can still enter anything I want in the cell. It has occasionally worked when I have done it however after doing it once, if I delete and try to re-enter the information it will then allow me to enter any format I want…can someone advise what I am doing wrong :slight_smile:

I am using Firefox browser

Hello,
Please provide a screen recording showing step-by-step issue reproduction