I use the latest version of Excel in a Windows 10 PC.
I live in Brazil, and we are used to use the European System of writing dates: DD/MM/YYYY. When using Excel, I can format the cells to showcase that way by changing the cell format to a Portuguese (Brazil) configuration, however whenever I want to input a new date in a cell I have to write it in the format MM/DD/YYYY for it to be recognized. I can't find a way to write it in our common format (DD/MM/YYYY). Can someone help me?