3 I know exactly what you are talking about. The setting to change it to what you want is not in Excel. The setting you want is in windows. It is hidden somewhere in the control panel "time and language". I had to go to an advanced setting "Change Time and Date Format" and change the "Short Date" setting. Hope this helps but also it is a good idea for the next video. Thank you for the question and please consider subscribing to our channel All the best
I have follow your method step-by-step. But when I choose my MDY format, then select Finish, then my original data is replaced with three columns with the month, day, and year displayed in each column. This is what typically happens when I use the Text to Columns function. Why is that not happening when you perform this function? What am I doing wrong?
![ประสบการณ์ จ้าง Developer ที่ผมจะไม่มีวันลืม [ภาค1]](http://i.ytimg.com/vi/bzivN4KDg-k/mqdefault.jpg)
This is the 3rd video I had to watch to figure this out. Thanks.
Thanks a lot for your nice comment! I am happy it helped! Please, consider subscribing to our channel if you like our content! All the best!
Very Helpful Video .. Had to watch many to fin this perfect one
Happy to hear that! Thank You for your nice comment and please consider subscribing to our channel! all the best!
Thanks alot ! You have just helped me with your invaluable video. So happy to overcome this issue 👍
Happy to help! Thanks a lot for your nice comment and please consider subscribing to our channel if you like our content.
all the best
this absolutely saved me, thank you so much
Glad it was helpful! Thank you for your nice comment and please consider subscribing to our channel! All the best!
Thank you for sharing this. I was stuck in a question because of this and this solved it 👍
Great to hear that! Thanks a lot for your comment and please consider subscribing to our channel if you liked our content. All the best!
Thank you for sharing the solution! It has helped me a lot!!!
Great to hear that! Thanks a lot for your comment and please consider subscribing to our channel if you like our content.
All the best
This actually worked thank you
That is great to hear! thanks a lot for your nice comment and please consider subsribing to our channel! all the best!
You are a G, you deserve your followers bro🌻
Thanks a lot for your nice comment! All the best
Thank you! Saved me so much time
You are so welcome! Thanks a lot for your comment and please consider subscribing to our channel All the best!
YOU ARE A LIFE SAVER!!!
Glad it helped! Thanks a lot for your nice comment and please consider subscribing to our channel! All the best!
Thank you very much this was helpful
You're welcome! Thanks a lot for your nice comment and please consider subscribing to our channel if you like our content! All the best!
Thank you so much it more helpfull and saved my time
Glad it helped! Thanks a lot for your nice comment and please consider subscribing to our channel! All the best!
What a champion! Thanks!!!
Thank You for your nice comment and please consider subscibing to our channel if you like our content! All the best!
thank you this worked perfectly!
Glad it helped! Thanks a lot for your nice comment and please consider subscribing to our channel if you like our content
All the best!
Thank you guy. I was in a bind
Glad it helped! Thank you for your nice comment and please consider subscribing to our channel! All the best!
Thanks for this video! very helpful :)
Thanks a lot for your nice comment and please consider subscribing to our channel if you like our content.
Best Regards
Thank you - very useful
Happy to hear that! Thanks a lot for your comment and please consider subscribing to our channel if you like our content.
All the best
Hi, if my date havent converted from text to column, then my original date text is yyyy-mm-ddThh:mm:ss , how should i change the setting ?
it's works, confirmed, thanks.!!
Glad it helped! Thanks a lot for your nice comment and please consider subscribing to our channel! All the best!
Thank you!!
You're welcome! Thanks a lot for your nice comment and please consider subscribing to our channel! All the best!
@@LearnTECH1 done! 🙂
thanks a lot man god bless
Glad it helped! Thanks a lot for your nice comment and please consider subscribing to our channel! All the best!
Good Job
Thanks alot man
Glad it was helpful! You’re welcome 😊 Please consider subsribing to our channel if you like our content! All the best!
Thanks!
Glad it was helpful! Thanks a lot for your nice comment and please consider subscribing to our channel if you like our content.
Best Regards
How to make the default date format to dd/mm/yyyy so that when i enter the date in that format Excel recognizes it as a date?
3
I know exactly what you are talking about. The setting to change it to what you want is not in Excel. The setting you want is in windows. It is hidden somewhere in the control panel "time and language".
I had to go to an advanced setting "Change Time and Date Format" and change the "Short Date" setting.
Hope this helps but also it is a good idea for the next video.
Thank you for the question and please consider subscribing to our channel
All the best
I have follow your method step-by-step. But when I choose my MDY format, then select Finish, then my original data is replaced with three columns with the month, day, and year displayed in each column. This is what typically happens when I use the Text to Columns function. Why is that not happening when you perform this function? What am I doing wrong?
U may have put the delimiter sign in the other section. Keep it blank
@@mayurkanth6987 Thank you! This solved my problem!
@@russellt7222 Welcome.
Thanks a lot for the suggestion. Best Regards
brilliant
Thanks a lot for your comment and please consider subcribing to our channel, if you like our content! All the best!
Not working for me....What might I be doing wrong?!
🎉thank you
Glad it helped! Thanks for your nice comment and please consider subscribing to our channel! All the best!