Forum Discussion
Issues with date in Excel
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.
tepaicruz You need to have a look at the regional date settings in Windows.
2 Replies
- Riny_van_EekelenPlatinum Contributor
tepaicruz You need to have a look at the regional date settings in Windows.
- tepaicruzCopper Contributor
Riny_van_Eekelen Oh my gosh! Thank you so much, it worked!