SOLVED

Issues with date in Excel

Copper 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 VI_Migration (Silver Contributor)
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!

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

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

View solution in original post