how to date format change in excel (dd/mm/yyyy) to (mm/dd/yyyy)

[@KAILASHBHATIA-kf4mu]

thank you very much it is very simple and easy to under stand excellent vidoe

[@pematso4501]

Thank you so much for sharing very helpful things
This is very helpful for me 👍👍👍👍👍👍🌞🌞🌞🌞🌞🌞🌞

[@sanatanmishra86]

Thank you so much ....very very happy ...only 2minit main shik geya ...

[@PankajKhede]

Thnx.....my presentation is complete.,

[@ICLCLASSES]

All the best

[@snp9434]

Good theory and practical....

[@TariqKhan-gc3pe]

** hi bhot behtareen sir G **

[@satmars520]

thanks a lot. This video has solved my problem with date format

[@kulvindersinghgollu1756]

bahut ache sir g..very thanks

[@jayeshvadhiya3050]

Good job... It was heplful..

[@ICLCLASSES]

THANKU SO MUCH

[@debaprasadmohapatra9235]

Very good tricks....Thanks

[@ICLCLASSES]

Welcome

[@SenthilKumar-xs1tc]

Your class is excellent and iam also learning hindhi

[@behappymusic7496]

Great bro within few min i got my answer 😇

[@kabir2272]

Thnk u respected sir.....for the video

[@ICLCLASSES]

My plzr

[@SaddamHussain-mo4tc]

Kamal sir ma Pakistan sy houn

[@kasulagovardhan968]

very useful information....

[@isakshaikh7348]

Thanks brother very very helpful..

[@krishankumar-mb7kg]

Great bhai
Thanks for your guidance
Maine seekh liya
Keep it up

[@priyankasinghpriyankasingh3154]

Thanks a lot
Excellent sir

[@kirandora817]

Thank you bro for you help.

[@ICLCLASSES]

Always welcome

[@pradeep.k900]

Thanks lot. I got what I think since last day's ago 🙏.

[@pujakushwaha115]

Unable to change date format ? Becouse Your Excel is not recognised date format so Check this video to solve this
ruclips.net/video/1aw_0IIJEyU/видео.html

[@110jaswindersingh]

Good and easy explanation

[@rupeshg1]

Nice information

[@soumitramakar9247]

Thank you sir...❤️

[@vganjaneyulu287]

Excellent job sir!
Thanks a lot!

[@sharemarkethackers380]

Thanks Guriji

[@ICLCLASSES]

my plzr

[@theindian6822]

thanks for help..🙏🙏🙏

[@dkentertainment9884]

Formula is very helpful

[@MegaCaptsparrow]

You could be more friendly ..you sound like old school Teacher 😂 but nice one

[@reetalgautam366]

very nice video sir thank you

[@saquibbodu6320]

very nice explain sir

[@DEBORAH_JOHNSON]

THANK YOU SO MUCH SIR, THANKS ALOT

[@rythu_king]

If we have different date formats like 24-01-2011 00:00:00 ,23/05/2022 12:00:00 AM how can we dd-mm-yyyy format.

[@swamyvangala8192]

Thank you so much

[@savyamallick998]

excellent..

[@yuvrajthakur4983]

Thank you very much sir....that was easy...🙏🏻🙏🏻

[@ICLCLASSES]

Thanku mr. Yuvraj

[@rawaikar1]

Excellent Video

[@rjtechp3820]

Thanks solve my prblm

[@tejalnetake8128]

Thanks a lot!!!

[@najminsultana8066]

দারুন

[@GAURAVYADAV0582]

Wow sir thanks very nice

[@kirandev-dk5rc]

Thanks a lot

[@ICLCLASSES]

Most welcome

[@vikram114]

Nice sir 👍👍

[@naeemurrahman2]

Thanks for ur information but I have a problem with formula bar formula bar Mai alag format hai our nechi alak format hai isko ak jasa kaise Karna hai Zara ye Hal karai plz

[@spverma3886]

Sir is pr datedif ka formula laga kr age count krna

[@sabihaparveen5088]

Thanks sir....it help me alot

[@satyamsikarwar4809]

Very nice

[@arul1964malar]

Good, Thank you

[@snehachaurasia2716]

29-03-2019 agar hame aisa chahiye hoga toh custom mein jake / ki jagah yeh - dalna hai na ?

[@basanrai9377]

Sir showing my in date's place ####### how do slove

[@kavelidivya9422]

Tq sir..

[@Aradhana-ef7ui]

Sir thank you but month or date to change ho jate hbut year same hi aa rha h use kese change karenge

[@chiranjeevig8740]

Thank you very much

[@pankajpankaj-tf4nb]

Super sir

[@chainsingh7390]

Thanks a lot sir

[@ICLCLASSES]

Most welcome

[@deepsagarnayak9173]

Thanks 🙏

[@ICLCLASSES]

You’re welcome 😊

[@pavanthechembull]

Only few dates were changing through this to mm/dd/yy. Rest of the cases remains like MM-DD-YY format only

[@Ravi-sharma0052]

Good job

[@damornarvatp.9605]

Good sir

[@sheikhasadahmed5886]

Like your way of teaching👍

[@abdulqadirkhattak7661]

Sir baaz dafa conditional formatting date py apply nahi hoti es ki kya waja hoti hai day ko wo month read krta hai.

[@hidayat111999]

ऐसा नहीं मेरे दोस्त। परमानेंटली कैसे चेंज करते हैं ये बताव।

[@kiranpawar9626]

Thanks 🙏 sir

[@sumitwadhwwa12]

Sir mera kaam transport ka hai usme insurance,fitnes,tax ke date exp hone se phle pta chl gya us sel ka clr cha g ho gya aysa krna sikna hai sir

[@rajanishkumar4556]

Sir Muje date ko ek ek box me auto fill karani ho to kaise kare? jaise kisi form me date ke liye 8 box diye hote hai usme auto fill karani hai.

[@Durgaprasadsahoogmail.comDurga]

Sir mere slas bala format bala hai usk minus kyese karu ap pehele likha Hua format main kyese karun

[@mahendrapujari7486]

Thnx Sir,,,,

[@ICLCLASSES]

Most welcome

[@bjygaming9]

great job

[@sujanshrestha3916]

Thanks bro

[@ICLCLASSES]

Sujan ji thanku so much

[@harshavardhana5907]

Thank you , I am new to excel, Need help !!, when I type this date 29/03/2019 and using the fill handle to drag down, the year changes but not the date or Month, please advise
29/03/2019
29/03/2020
29/03/2021
29/03/2022
29/03/2023
29/03/2024
29/03/2025

[@udaancomputerclass561]

Hii
Use fill function which is given on home tab at editing group
Select coloum
Select date
Select day
Then ok

[@mithileshkrray8196]

Nice

[@FunnyVideos-fp8pv]

Good

[@sapiarrahaman9218]

Mobile me Excel sheet me date format kayse change kare

[@Devil-bc9ff]

thanks

[@ICLCLASSES]

Thanks a lot

[@Hemshankarmandal-c5z]

nice

[@dare_to_DIY_6571]

Please Kai date of birth likhi hui hain unme serial se date serial se month's & serial se years kaise likhe Jaye ? Humne bahut koshish ki per nhi sequence month's & year nhi ata hai? Please tell me

[@shivamsingh-pr5qo]

Thankyou 👍

[@sukhdevlagdhir1475]

By default humko ek list mai Sare logo ka DOB enter karna ho toh kese?
I mean we should only write digits (12122005) and after pressing enter it should change to 12-12-2005

[@hardikkadakia]

=Text(value, "dd-mm-yyyy")

[@harshadvarsani5826]

Agar pehle se 01/sep/2022 likhahe aur usko chqange karke 01/09/2022 karna he to keise change kare

[@skdaveskdave9798]

I want to know the formula if in column have 1,3,4,6,7 wish to convert in side column as Jan,Mar,Apr,Jun,July intimate in hindi

[@udaancomputerclass561]

Sir,
Using text formula this Query would be slove
=Text(cell number,"mmm")

[@surendarbamniya9264]

Excle me date dalty hai is formet se 01-02-2020 to date ka formet is trah change 01/02/2020 kiyu hojata ha plz reply me

[@krishnaguduri6473]

Sab data me - hai aur hame / karne hai aur date serial nai hai tho kya har ek ko edit karna padega

[@snehadhar5257]

Hi Thanks!
How to change the dates to a single format if the format is mixed in a colums. Eg, 29.9.2010 and 20/7/2019 in the same column, how to get it in one format?

[@udaancomputerclass561]

Hii,
Using text to coloum function your query would be slove
Data tab
Text to coloum
Without change anything click on next
Select date format
Then finish

[@anishalok6548]

@@udaancomputerclass561 what's formula please explain me

[@virendrakashyap852]

THANKS sir

[@taniyaganguly2837]

👍👍

[@rohitkumar618]

Ye dob k dono format correct h na sir ji 🤔🤔🤔

[@satishjain5815]

Sir mobile no mill swkta he kiyw

[@MilanKvideos9024]

Thnaks

[@NaushadAlam-ex9zo]

thanku sir

[@ICLCLASSES]

Nausad Alam thanku so much for watching my video

[@mahmoodmakkah9282]

Thanks,

[@Ericaaaaaaa2424]

Thanks!

[@shaahidkhan8607]

Can we permanently set the date format to indian format ???

[@rashmimohanty4216]

Really excellent 👍👍👍👌👍

[@Anjalisingh_30520]

Sir jese today date k hisab se hame 6month bad ka date chaiye to kese karenge

[@sweetydidi3515]

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? '

[@SandeepRawat89]

Thank u sir

[@burnsy96]

Do you have an English version?

[@salman3609]

Same date. Chahiye all column me

[@humainfatima3445]

I select DD/MM/YYYY but after selecting day transfer in month and month in day 😢
But pattern is same like this
Eg. DD/MM/YYYY is 04/07/2023 when i choose the format it shows like 07/04/2023 😮😢

[@girishkumar-rp8tm]

tq boss

[@Makstar9335]

Sir kya me ek date likh kar date aur month show kar sakta hun??
Jese mene likha 10
To ye date convert hokar 10-01-2021 me convert ho jaye..
Plz sir tell me....