How do I create MM/DD/YYYY date format restrictions in Excel ? Means if anyone enter date other than this format then it should not accept and they should get prompt to enter date in MM/DD/YYYY format.
hello sir , I am one of your subscribers. I have a question I kindly want you to answer as soon as possible. whenever I want to type day, month, and year and time in one cell like this ( 16/02/2021 10:20 In one cell actually) it changes to( 02/16/2021 10:20 ) month comes before day how to solve this? please answer !
How to change date format in multiple cells and columns, actually I am facing error while change date format (e.g. in a column some cells in correct date format and pending cells in wrong date format that time I select whole column and change date format but changes not done) please explain
Sir agar kisi ka age only year me diya hai to usko dd/mm/yy form me kaise convert karenge? Jaise kisi ka birth year 1991 me ho to usko 01/01/1991 me convert karne ke liye kaun sa formula lagana padega? '-
Thank you so much dear it's very helpful for me thank you again
Thank you sir it's very useful information
Thanx bro.....very helpful for me👍👍👍👍
How do I create MM/DD/YYYY date format restrictions in Excel ? Means if anyone enter date other than this format then it should not accept and they should get prompt to enter date in MM/DD/YYYY format.
Just saved me from failing a test 😂
Thanks you bro.this video is very helpful for me
Nice and easy thx sir
Useful information
Hi bro...tanx for introducing format cells to me😁😁❤️
Helped at the right time. Ok thanks sir
Glad it helped
YOU SAVED MY LIFE THANK YOU!!!
Very useful. Thanks! I think you can also use custom formats.
hello sir , I am one of your subscribers. I have a question I kindly want you to answer as soon as possible. whenever I want to type day, month, and year and time in one cell like this ( 16/02/2021 10:20 In one cell actually) it changes to( 02/16/2021 10:20 ) month comes before day how to solve this? please answer !
Very useful and smartly made video
How to keep capital date format as (06 OCTOBER 2021) on Excel Sheet, Please help ?
Hi, I need some help on an excel sheet. Where can I send you the file so you can have a look at it and suggest if you can assist
Thank you so much for sharing ❤
That was fantastically simple, thank you
How to change date format in multiple cells and columns, actually I am facing error while change date format (e.g. in a column some cells in correct date format and pending cells in wrong date format that time I select whole column and change date format but changes not done) please explain
Thanks Sir for this video he help me to convert date language...
You are great sir
Well done
Sir agar kisi ka age only year me diya hai to usko dd/mm/yy form me kaise convert karenge? Jaise kisi ka birth year 1991 me ho to usko 01/01/1991 me convert karne ke liye kaun sa formula lagana padega? '-
how to you update the date format to AUS when you are already set to format AUS and the worksheet is an output of an SQL with US date format
Very good video
Thanks for date formulas 🌺🌺
Which ms office version did you used ?
Thank you so much, ur video was really helping
Thanks you sir 👍
Isn't there any syntax for the same ? If there is syntax then give it.
Superb
Such a relief finding out how to do it. I’ve been doing txt to column on data tools🤬 f&$@ me dead.😤thank you for doing this🙏
This really helps. Thank you.
Thank you 😊
Good job
good video
Thank you very much. you solve my very important problem. Thanks a lot.
Very useful
Thank you man! God bless you 😚
thank you, it's really helpful for me.
Thank you Sir
Lifesaver, thank you 😀
Thanks bro
Thank you 🌸
Thanks, for easy solution.
thank you. 😊
Thank you for the info🙏🏻..
Thank You
TQ MJ
Thanks dear, good bless you.
Thanks man
Super thank you
I tried to change to format YYYY-M-D IN english uk location but it doesnt change. Can someone explain to me?
Thank you, very useful!
I have to know one thing how to see in same Format dd/mm/yyyy after filter
Thankyou ❤️
Thank so much brilliant
Jay ho Jay Hind
Thanx lifsaver
Thanks
Thnk U Vary much sir for help
Why does it change back when I want to erase a number? It changes back to the American format. Super annoying
Tq bro
Thank u
Thank youi
what is data is constantly updating? and its not working?
How u can go in DD.mm.yyy format to this date
No format cells option???
Tq Bhai ❤️
Thanks alot
Thankyouu
can you teach me how to change data in excell
You are my godd
I have done same process 4-5 times still it's not changing
dear
how to mabile excel date to time remove
Not worked in case
ans please mi type 10-20 but click enter change date and another amout
Legend
hi i time traveled into 2051 we have flouting cars
Thank you...
Thank u sir thank u sooooo much
how to convert 5 November 2016 to 5/11/16
Malayali
nhi ho raha😢
Its not changed bro
Nahi hoa
1:10
Clerty ledu
Loka udayipppp
He did nothing
Thank you.. 👍
Thanks bro
Thanks a lot sir
Very useful
Thanks
Thank u
Thank u sir
thank you!
Thank you
Thank you