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 :(
@ExcelatWork
5 ай бұрын
Yes, we found the same thing! So frustrating!
@kaeldrarhiannon
Жыл бұрын
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.
@ExcelatWork
Жыл бұрын
Hi there. Maybe try following this video kzitem.infoFxRIuRMeRLQ. I hope it helps.
@colinmalley3904
Жыл бұрын
Thank you sooo much - this has been puzzling the team using a shared spreadsheet! 👏
@ExcelatWork
Жыл бұрын
You're so welcome!
@pareyesg
Жыл бұрын
Really really thanks, you save my excel mess!!!
@ExcelatWork
Жыл бұрын
Yay! Thank you! I'm so glad it helped!
@niranjannaikwadi
Жыл бұрын
5 videos later and someone finally shows how to get it done on Excel Online, goodness. Bless you!
@ExcelatWork
Жыл бұрын
You're welcome. I'm so glad it helped!
@siminakhlaghi5466
2 жыл бұрын
Hi, How can i have date like this,: friday 30 june 2016 ?
@ExcelatWork
2 жыл бұрын
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 😊
@natalyadubikova7905
Жыл бұрын
thanks a lot: very helpful - it works!)
@ExcelatWork
Жыл бұрын
You're welcome. So happy it worked for you!
@TheLastCoconut
Жыл бұрын
I have shared this video thanks
@ExcelatWork
Жыл бұрын
Thanks for sharing!! Thank you!
@thirtythreellp1251
2 жыл бұрын
thanks for helping me solve a problem I've left unsolved for over a year 🙂
Пікірлер: 22