Whilst this seems to work for myself, I'm finding every user that accesses the file via MS Teams needs to change the regional settings......... Not ideal :(
6:33 does NOT work. There was no instant updating of cells, my dates are still being interpreted as text format by Excel and I can't get the stupid thing to change.
In Excel Online, right-click the cell holding the date, select Number Format, select Date. There is a date option that is close to your requirements in there. In the Desktop version of Excel, right-click the cell, select Format Cells, select Date and select the format you require. Both of these options do have a comma after the day. In Excel Desktop only you can overcome this by creating a custom date using the following format: dddd dd mmmm yyyy. I hope this helps 😊
5 videos later and someone finally shows how to get it done on Excel Online, goodness. Bless you!
You're welcome. I'm so glad it helped!
Thank you sooo much - this has been puzzling the team using a shared spreadsheet! 👏
You're so welcome!
thanks for helping me solve a problem I've left unsolved for over a year 🙂
You are so welcome!
Really really thanks, you save my excel mess!!!
Yay! Thank you! I'm so glad it helped!
Best video ever thank you sooooo easy !!!! 👌👍
Thank you! So glad it helped you out 🙂
Thank you so much, you nailed it!
Yay! Glad it helped!
thanks a lot: very helpful - it works!)
You're welcome. So happy it worked for you!
I have shared this video thanks
Thanks for sharing!! Thank you!
Whilst this seems to work for myself, I'm finding every user that accesses the file via MS Teams needs to change the regional settings......... Not ideal :(
Yes, we found the same thing! So frustrating!
6:33 does NOT work. There was no instant updating of cells, my dates are still being interpreted as text format by Excel and I can't get the stupid thing to change.
Hi there. Maybe try following this video th-cam.com/users/shortsFxRIuRMeRLQ. I hope it helps.
Hi, How can i have date like this,: friday 30 june 2016 ?
In Excel Online, right-click the cell holding the date, select Number Format, select Date. There is a date option that is close to your requirements in there. In the Desktop version of Excel, right-click the cell, select Format Cells, select Date and select the format you require. Both of these options do have a comma after the day. In Excel Desktop only you can overcome this by creating a custom date using the following format: dddd dd mmmm yyyy. I hope this helps 😊