Hi, dates in my excel are visible as numbers whereas in formula bar, it can be as a date in correct format. Plz suggest what can be done to rectify this.
bhaiya how did u hide the data , paste special is not working because of hidden column, I havechecked 10-15 video and was looking for same kind of date problem only your video helped me, but facing issue with paste special
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.
Maine jo data type kiya hai usme maine dd-mm-yyyy fill kiya tha lekin jb filter krta hu to wo month ko date me count krta hai or date ko month me main chahta hu date or month apas me change na ho or apne sthan pr bane rhe or dd-mm-yyyy ki tarah behave kre
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?
You are great✌🏻👍🏻...trust me I watched 4 channels didn't get proper answer. Please follow very easy method of learning.
Thanks aarti
Great Job bhai,
Amazing...Thanks for this video.
Thanks Mukul, your example solved my problem.
Welcome
good job
Thank you very much it helped me a lot
this is exactly what i was looking for tq man
very nice explanation ... keep it up
Thanks a lot
Excellent brother.......it is working ......Thankq so much
bravo, perfect workaround.
It worked, you saved me out from shit.
Hi, dates in my excel are visible as numbers whereas in formula bar, it can be as a date in correct format. Plz suggest what can be done to rectify this.
Change into a date format
It worked thanks so much
THANKS FOR CONVERT ALL DDMMYY FORMATS
Welcome
Thanks for this info ❤️❤️
bhaiya how did u hide the data , paste special is not working because of hidden column, I havechecked 10-15 video and was looking for same kind of date problem only your video helped me, but facing issue with paste special
Very helpful 👍
Thanks Bro
Thank you so much...I didn't find it anywhere 😅👍
Welcome
Fill Handel se kewal 12 tk hi date fill hoti hai kya kre....???
Solution btao bhai...
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.
Post ur query in my fb advanced excel tricks group
bro what have done at 02:58 please tell?
Sir hamare yaha 1 to 12 Tak hi drag hoti hai date.
Aage drag Kiya to agle month se ata hai..plz help
Hi Mukul when I split the day , months through flash fill I don't know why the month 10 comes 0 it remove 1 it happens for all two digit numbers
instagram.com/excelwithmukul watch latest video
@@ExcelWithMukul I am getting the same issue when trying the method shown in the above video. Kindly share the exact video link to check.
Hello sir Mera Excel file mmddyy ke format m save ho gya h all cells usko ddmmyy format m kaise kru plz guide me
Use number formatting
Maine jo data type kiya hai usme maine dd-mm-yyyy fill kiya tha lekin jb filter krta hu to wo month ko date me count krta hai or date ko month me main chahta hu date or month apas me change na ho or apne sthan pr bane rhe or dd-mm-yyyy ki tarah behave kre
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?
Jun 15, 2021 -- is date ko excel me kaise convert kar sakte hain mm/dd/yyyy format me
Use custom format
Great
Thanks
It is big problem in GSTR 2 B EXCEL FORMAT DATE CANNOT IN PROPARE FORMAT HOW DO IT?
elaborate your question pls
It's easy to write c program than this procedure, it's so much complicated.
Yr plz meri ek problem solve kr do meri office file me date 12-feb-2021 ese hai but me 12-FEB-2021 ESE CAPITAL ME KRNA HAI PLZ TELL ME
Sure I will help u soon
Hume date seprate karne ke liye date month aur year ki alag likha lekin control e press karne kuchh bhi nhi hua
Aapka old version h excel ka...flash fill keval 2013 or uske baad vaale version m use hota h
Are bhai isko starting se samjhao
very nice explanation ... keep it up
Glad you liked it