SOLVED

Issues with date in Excel

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3146862%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EIssues%20with%20date%20in%20Excel%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3146862%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EGood%20morning.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20with%20inputting%20dates%20in%20my%20Excel%3F%20On%20my%20previous%20laptop%2C%20when%20I%20put%20a%20date%2C%20it%20automatically%20changes%20to%20the%20default%20date%20format.%20For%20example%2C%20I%20put%20Feb%2010%2C%20it%20automatically%20changes%20to%2002%2F10%2F2022.%20But%20now%2C%20when%20I%20put%20in%20Feb%2010%2C%20it%20changes%20to%2001%2F02%2F2010.%20Also%20when%20I%20input%20a%20whole%20date%20like%20February%2010%2C%202022%2C%20it%20doesn't%20change%2C%20it%20stays%20as%20is.%20But%20on%20the%20my%20previous%20laptop%2C%20it%20automatically%20changes%20again%20to%20the%20default%20date%20format.%20Is%20there%20a%20setting%20I%20need%20to%20change%20for%20it%20to%20automatically%20change%20into%20the%20default%20date%20format%3F%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3146862%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Good morning.

 

Can anyone help with inputting dates in my Excel? On my previous laptop, when I put a date, it automatically changes to the default date format. For example, I put Feb 10, it automatically changes to 02/10/2022. But now, when I put in Feb 10, it changes to 01/02/2010. Also when I input a whole date like February 10, 2022, it doesn't change, it stays as is. But on the my previous laptop, it automatically changes again to the default date format. Is there a setting I need to change for it to automatically change into the default date format? 

 

Thanks.

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@tepaicruz You need to have a look at the regional date settings in Windows.

@Riny_van_Eekelen Oh my gosh! Thank you so much, it worked!