Date input in cells using European Style

%3CLINGO-SUB%20id%3D%22lingo-sub-2741880%22%20slang%3D%22en-US%22%3EDate%20input%20in%20cells%20using%20European%20Style%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2741880%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20the%20latest%20version%20of%20Excel%20in%20a%20Windows%2010%20PC.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20live%20in%20Brazil%2C%20and%20we%20are%20used%20to%20use%20the%20European%20System%20of%20writing%20dates%3A%20DD%2FMM%2FYYYY.%20When%20using%20Excel%2C%20I%20can%20format%20the%20cells%20to%20showcase%20that%20way%20by%20changing%20the%20cell%20format%20to%20a%20Portuguese%20(Brazil)%20configuration%2C%20however%20whenever%20I%20want%20to%20input%20a%20new%20date%20in%20a%20cell%20I%20have%20to%20write%20it%20in%20the%20format%20MM%2FDD%2FYYYY%20for%20it%20to%20be%20recognized.%20I%20can't%20find%20a%20way%20to%20write%20it%20in%20our%20common%20format%20(DD%2FMM%2FYYYY).%20Can%20someone%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2741880%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2741970%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20input%20in%20cells%20using%20European%20Style%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2741970%22%20slang%3D%22en-US%22%3EI%20expect%20the%20problem%20is%20that%20your%20computer%20Windows%20system%20locale%20is%20set%20to%20US.%3C%2FLINGO-BODY%3E
New 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.