Date input in cells using European Style

Copper Contributor

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!

1 Reply
I expect the problem is that your computer Windows system locale is set to US.