Sep 10 2021 10:00 PM - edited Sep 10 2021 10:03 PM
Hi!
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?
Thanks!
Sep 10 2021 11:22 PM