Time saving trick: Quick Convert Text to date in Excel

[@salmafauziaazka]

ya Allah makasih berkat video ini aku ga nangis lagi😭 Its super helpful, thank you so much🥺❤

[@kailashbhatia-h7e]

sir thank you vey much for video very informative and valuable in practical date format gives lot of trouble your explanation will solve the problem

[@timskinner5184]

Brilliant! Saved me re-writing 400+ cells, thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there

[@rggamitgamit9299]

Thank u for saving my time and finally i present my sheet perfectly

[@PKAnExcelExpert]

Most welcome 😊

[@dileepmaurya5632]

Thanku so much sir for sharing this knowledge. Sir I am changing 10.2.2021 this date and this date is in text I want to change in date by excel macro. Please help as soon as possible. 🙏🙏

[@KumarSingh-zc3iw]

Finally... my requirement completes here. Thanks dude for such a fantastic excel information.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@vipinkumar-le7yf]

I, m also facing same problem since 1 month now my problem solved by this video

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@nithikasn]

Dear PK! Kamal ye yaar! thank you for solving my issues. Text to column "MDY" function Delimited AWESOME!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Manoj_Ambekar]

Thank you very much. It is very helpful. It works great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@spnn4s106]

wondering if there is a way I can export my outlook calendar into Excel so I can see al my weekly and bi-weekly meetings and make a meeting cadence spreadsheet. Thank you

[@leebalaila4760]

Thank you. This video helped me solve my date problem.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@iwantovani3727]

Thanks bro, it very helpful to resolve my problem. Greetings from Indonesia.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anuppatel5807]

Thank you so much.... It solved my problem....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@zlumbers]

Thanks, this is what I'm looking for

[@PKAnExcelExpert]

Glad I could help

[@vaibhavdhanwate7182]

Solved my big problem. Very Helpful, Thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AdnanMohmand]

Millions of thanks for resolving my issue.

[@skyblue2337]

Thank you for sharing this video, very helpful. Please continue sharing such informational videos. Thank you again.

[@wstibbs1]

Thank you! Great help for my early morning frustration!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AmitAgarwal1977]

Excellent Video

[@pinakimajumdar3788]

Thanks for sharing

[@PKAnExcelExpert]

Most welcome🙏

[@siaozam]

best ever advise! was a mystery to me for ages

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there.

[@anushkasampath1647]

Hi .Thank you very much for information. However, I want to ask you something other than this. Let say, different formats of date is included in a one coloumn in a large data sheet, what would we do to arrange it properly. For example first 20 rows as DMY order and then YMD.

[@yatiraghuvanshi7753]

Thank you so much...much useful and short video

[@PKAnExcelExpert]

You are most welcome

[@sanofamotivation]

Thank you it was very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DineshMakwana7]

Hello Sir, very useful all videos, just need one information can we find date in excel sheet....

[@marcelodelmastro8792]

Thank you so much!!!!! That will save me a lot of time!!

[@soc2rob]

Thank you! You saved me hours

[@PKAnExcelExpert]

Glad it helped!

[@rajeevgosavi4514]

Very well explained Sir. You have made life so easy.Thanks . We also request you to upload a video with downloadable worksheets to cover power query fully.

[@Ohmystarz1]

Helpful, thank you.

[@PKAnExcelExpert]

Most welcome

[@amazinggrace6927]

Thanks a lot, this saved me

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@JofelTanAC]

Very Helpful. Thanks You so much.",

[@PKAnExcelExpert]

Most welcome🙏

[@comnetcns1]

Great contents Sir, surely helping in day to day MIS analytics work, thanks for update us

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@JigneshPatel]

Nice. Very good.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@venkatsubramanian9978]

Very usefull

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@smkumarphone]

Thank you so much. The was much helpfull for me.👍

[@PKAnExcelExpert]

Glad it helped!

[@muthuraja6589]

Useful for me and our team mates. Thank you sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please share this video with your team also.

[@muthuraja6589]

Sure sir

[@rubs63]

thank you, so much ...That was really very helpful !!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anjaneyulukodam9961]

Thanks alot for your kind explanation about the date format that was most useful in routain. Good night sir,

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@elvisjmartis]

Thank you so much. It was really helpfull

[@PKAnExcelExpert]

Glad to hear that!

[@syedabdullah5259]

Very nice

[@PKAnExcelExpert]

Thanks

[@jackyvivid]

can you tell how to do same in OpenOffice? Where i work they have openoff

[@kiranghadi7088]

Can we change multiple column date format at one time using text to column

[@neilbiggin]

This has been a huge help to me, many thanks.

[@PKAnExcelExpert]

Thank for your valuable feedback

[@vijayfulwar6172]

Hi Priyendra sir, This is really good and much helpful n real working environment. I am learning a lot by watching your videos. Thanks a lot for your videos and lnowledge sharing.... Everytime realize that there is so much to learn....

[@PKAnExcelExpert]

Thanks Vijay, For your valuable feedback.

[@smabdullahalmahmud8499]

Thank you so so mauch!

[@PKAnExcelExpert]

Thanks for watching

[@HaroonKhan-vi6kh]

PK: An Excel Expert I have different formats of dates in one column some in DMY and some in MDY and secondly some dates are saved as dates and some as text. Please explain how to format it properly. Tnx

[@srikrishna80]

Hi PK. Love your videos. I am looking for a way to auto populate a calendar when my team updates their appointment in another sheet. My sheet consists of the following data - 1. Customer name 2. Sales status (Each Status has a color code) and next appointment date. When they change a date against a customer, is it possible to auto populate their calendar in that date with the customer name (color coded in the same color as the status)?

[@gobisekaran5102]

Tons of thank you for solving my issues. How to get age using excel in particular date that means as at 31.12.2019

[@syedabdullah5259]

Thanks a lot

[@PKAnExcelExpert]

Most welcome

[@reshmagandhi7667]

Thank you so so so so so so so muchh.. you were really helpful !!

[@ngujennifer3066]

Pls guide, why when I format my text to date, all turn up as ######### in the cells but when look at the cell formula, its correct. Thank you!

[@Dilsehandsome]

Thanks

[@PKAnExcelExpert]

Welcome

[@arunkumar-tt5wc]

Usefull video tq❤

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ikramcomputerzonemandani7116]

THANKS SIR

[@PKAnExcelExpert]

Most welcome

[@FRANKWHITE1996]

great! thanks!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@muslehuddinmuzammil3071]

I owe you a thumb up buddy,

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@stanislassembinelli1821]

Really helpful!! Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained

[@PawanYadav_the_professor]

THANKS !!!

[@PKAnExcelExpert]

Most Welcome.

[@pinxpillay134]

Thank you dear , thanks for showing a quick and easy way to fix the dates

[@brandonchin6731]

Super helpful. Thanks a lot man!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohie63]

Indeed one of the best tips ever, thanks :)

[@PKAnExcelExpert]

Thanks for your appreciation. Please share it with your friends and colleagues.

[@gercris70]

Thank you so so so so so so so muchh.. you were really helpful !! For me this was a life saver!!!!

[@PKAnExcelExpert]

Thanks for your appreciation. Please share it with your friends and colleagues whoever is needing this.

[@muradalabsy2862]

Thank you you are my hero

[@PKAnExcelExpert]

Thanks for your appreciation. Request you to please share this with your friends and colleagues.

[@excelavon]

Very Nice Trick

[@dharmendrayadav-bw2gp]

Nice video sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vinayakpotadar4093]

Nice sir moreover any Idia s for dates converts from text & short cuts more sir.

[@jackjimenezpereda9252]

Excelente amigo. muchas gracias

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there.

[@jafarsadiq.a7481]

Thank you Sir

[@PKAnExcelExpert]

Thanks for watching

[@dope3.142]

i love you bhai thanks

[@PKAnExcelExpert]

Most welcome

[@VINAYKUMAR-lo4ci]

Good

[@PKAnExcelExpert]

Thanks

[@andrejholasek7916]

thanks, it helped me a lot!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ashvinkallee143]

Similarly, please explain how to convert text to time.

[@vamique]

Thank you..

[@PKAnExcelExpert]

Thanks for watching

[@abdoharbi]

good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@braj72]

Thank you

[@PKAnExcelExpert]

Thanks for watching

[@gidovanmastrigt4106]

I need to convert following text " 01 February 2020" to date. Is this possible?

[@oddnumber8149]

he will not answer back

[@SIMRANKAUR-eg7nc]

I don't think anything like this possible. U can do 1 thing though use if then to assign 1 to jan 2 to feb ........ And when no are there use text to column for separating and changing to dates. U can check channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there.

[@Dev_Bartwal]

i have a series of numbers like 1052018,12052018,3052018 these are dates (1-may-2018)..... how to convert to date series of numbers plz help ( text to column is not work properly)

[@muthuraja6589]

Hi bro just try it may be it will working Column b type date format like 16Nov2018 then click column a ctrl+down arrow then move column b then Ctrl+shift+up arrow Now u press Ctrl+E...you get a ans

[@gauravshakya1783]

any one help for this issue?

[@muthuraja6589]

@@gauravshakya1783 plz mentioned your email id

[@venu09051983]

Apply this formula to your series of numbers =Text(A1,"##-##-####") Here A1 is cell number Now your series of numbers will be converted into 12/05/18 Now copy that cell and paste some where else as paste special 'values' Then follow above video method

[@venu09051983]

I forgot quotes in above formula =Text(A1,"##-##-####")

[@Excel-power-users]

Hmm nice one

[@omkarkelshikar7484]

Helpful video sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mkitessa]

Helpful thank you!!!!

[@PKAnExcelExpert]

Thanks for your Valuable feedback.

[@maheshhadke14]

I hv put 11 out of 20 (11/20) but it taks it as date But I need it as simple 11/20 as number

[@nithikasn]

Dear PK, I am doing Technical report in Excel i need to produce a MS-Word report using mail merge at the same time one tap all the excel data should automatically typed in MS-Word report I tried.But failed .They used some external link/macros.I cannot understand Please give me your email ID.I will forward the excel sheet & Word report

[@iamdell5544]

Any formula about this

[@ModernPindawale]

Sir English to Hindi main convert krne ke liye Kiya kre

[@sharonvoosa8160]

tq

[@madhupa577]

Nice

[@PKAnExcelExpert]

Thanks

[@BachXuanHien]

good, thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@leukas723]

I am trying this method but nothing happens.

[@Dev_Bartwal]

How to covert 1052028,2052028 in date help bro

[@SIMRANKAUR-eg7nc]

If figures r consistent it is possible I mean 2 digits each for day and months and 4 for years. Extract by text to column and opt width instead of delimited and mark the partition accordingly.

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there.

[@durgesh91tomar]

👍

[@PKAnExcelExpert]

Thanks

[@oddnumber8149]

if you have 2-April-2020 doenst work

[@PKAnExcelExpert]

2-April-2020 is already an excel date format. It will work when your date format is a text according to excel. for example - 02.04.2020 or 02042020

[@ConsulthinkProgrammer]

Text to date: kzbin.info/www/bejne/baann3mVp62Zia8

[@LokeshKumar-vo4fv]

Bhai hindi bol leta to kya ho jata ..

[@hemantkumarbadiger443]

Stick to the point

[@manojkrishnan8461]

Thank you so much

[@PKAnExcelExpert]

Thanks for watching

[@ramkumar-cv9hl]

Thankyou

[@PKAnExcelExpert]

Welcome

[@alexrosen8762]

Very good

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@jithujoseph1324]

Thank you so much

[@PKAnExcelExpert]

Welcome

[@Crackitacademy]

thanks brother

[@PKAnExcelExpert]

Welcome

[@saumyaagrawal9892]

Thanks

[@PKAnExcelExpert]

Thanks for watching

[@Raushankumar-de5mr]

Thank you sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ajaykumargupta8504]

Thanks

[@PKAnExcelExpert]

Welcome