Date defaults to Month and year

%3CLINGO-SUB%20id%3D%22lingo-sub-3526089%22%20slang%3D%22en-US%22%3EDate%20defaults%20to%20Month%20and%20year%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3526089%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20type%20in%201%2F4%2F2022%20the%20cell%20defaults%20to%20Apr-22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20stop%20this%3F%20What%20settings%20do%20i%20need%20to%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDavie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3526089%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3526399%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20defaults%20to%20Month%20and%20year%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3526399%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1429246%22%20target%3D%22_blank%22%3E%40davie1965%3C%2FA%3E%26nbsp%3BThe%20cell%20(or%20cells)%20you%20are%20typing%20in%20are%20probably%20custom%20formatted%20as%20%3CSTRONG%3Emmm-yy%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EChange%20the%20cell%20format%20to%20Date%20and%20it%20should%20pickup%20the%20format%20in%20accordance%20with%20the%20settings%20on%20your%20computer.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

When I type in 1/4/2022 the cell defaults to Apr-22.

 

How can I stop this? What settings do i need to change.

 

thank you

 

Davie

1 Reply

@davie1965 The cell (or cells) you are typing in are probably custom formatted as mmm-yy

Change the cell format to Date and it should pickup the format in accordance with the settings on your computer.