Tried That. Been trying to enter 01/09/2022 (Day/Month/Year European Format) in Excel But somehow it keeps being registered/Changed as 09/01/2022 (Month/Day/Year). Why is The Month September Being Placed First?
I did like this video and it's very easy to follow. However, I have followed this process more than several times to change my date format to mm/dd/yy and no matter how many times I do it, it WON'T change the date format to what I want. There has to be an explanation for it not working like your procedure in the tutorial. any advice on this ? Thanks !
omg I'm literally doing this now & it doesnt work either for me. I want to change the date format from mm/dd/yy to words but it doesnt change at all :"""""""
I assume you don't need my help anymore, but for anyone else that has this same problem I just figured it out. You need to highlight the dates the click the Data Ribbon> Text to Column. Hope this helps someone maybe look up a specific tutorial for text to column.
my excel doesnt show "/" if the cell is formated as date. i even checked the format cell and converted to text. im so lost. the "/" apears if i put Name/Name but moment i put in 5/5 it converts to "05 May" or "5 05 2024" without "/" help ?
Im doing exactly this: i have a row of dates formated D/M/Y which i want to change to M/D/Y. i follow these steps and nothing happens! God i hate excel!
This has really helped me. I’ve been struggling for days. Thanks
thank you very much. Your channel makes excel soo easy
Thank you so much, I have been assisted.
Your explanations are clear. Keep it up.
super simple explanation and was easily able to implement the steps with success. thanks!
Thank you sir, really helpful
Tried That. Been trying to enter 01/09/2022 (Day/Month/Year European Format) in Excel But somehow it keeps being registered/Changed as 09/01/2022 (Month/Day/Year). Why is The Month September Being Placed First?
Thank you
Thanks, super helpful.
Thanks!
THANKS
thanks very very much
I did like this video and it's very easy to follow. However, I have followed this process more than several times to change my date format to mm/dd/yy and no matter how many times I do it, it WON'T change the date format to what I want. There has to be an explanation for it not working like your procedure in the tutorial. any advice on this ? Thanks !
omg I'm literally doing this now & it doesnt work either for me. I want to change the date format from mm/dd/yy to words but it doesnt change at all :"""""""
I assume you don't need my help anymore, but for anyone else that has this same problem I just figured it out. You need to highlight the dates the click the Data Ribbon> Text to Column. Hope this helps someone maybe look up a specific tutorial for text to column.
@@Beshee7 You are a hero. This worked for me! many thanks
@@Beshee7 Thanks a lot man, been struggling for many hours
I'm using Google Excel and I don't have that option when right-clicking (?). Any ideas? Thank you!
my excel doesnt show "/" if the cell is formated as date. i even checked the format cell and converted to text. im so lost. the "/" apears if i put Name/Name but moment i put in 5/5 it converts to "05 May" or "5 05 2024" without "/" help ?
so you have to do this for every date enter cant you change it to always be day month year
It dosnt change for me it still says Mar 14, 4:35pm for example and I want it to say 3/14/24 16:35.
thanks.
You’re Welcome :)
If data contain 20230901 date how to change this
I want date-month- year example 01-Jan-20 . please help me its very urgent
Made it to the right house click lol
Im doing exactly this: i have a row of dates formated D/M/Y which i want to change to M/D/Y. i follow these steps and nothing happens! God i hate excel!
not working