Time saving trick: Quick Convert Text to date in Excel

Time saving trick: Quick Convert Text to date in Excel

PK: An Excel Expert

6 лет назад

104,500 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@user-nr4zs5em2b
@user-nr4zs5em2b - 26.08.2023 06:28

Very Helpful. Thanks You so much.",

Ответить
@smkumarphone
@smkumarphone - 17.08.2023 05:22

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

Ответить
@pinakimajumdar3788
@pinakimajumdar3788 - 21.03.2023 04:26

Thanks for sharing

Ответить
@jackyvivid
@jackyvivid - 20.01.2023 16:07

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

Ответить
@yatiraghuvanshi7753
@yatiraghuvanshi7753 - 04.11.2022 13:31

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

Ответить
@dope3.142
@dope3.142 - 07.09.2022 04:41

i love you bhai thanks

Ответить
@rggamitgamit9299
@rggamitgamit9299 - 21.08.2022 06:33

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

Ответить
@soc2rob
@soc2rob - 31.03.2022 19:17

Thank you! You saved me hours

Ответить
@HaroonKhan-vi6kh
@HaroonKhan-vi6kh - 23.03.2022 11:36

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

Ответить
@salmafauziaazka
@salmafauziaazka - 21.03.2022 16:02

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

Ответить
@zlumbers
@zlumbers - 20.03.2022 16:19

Thanks, this is what I'm looking for

Ответить
@ikramcomputerzonemandani7116
@ikramcomputerzonemandani7116 - 24.02.2022 11:15

THANKS SIR

Ответить
@spnn4s106
@spnn4s106 - 22.02.2022 22:22

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

Ответить
@VINAYKUMAR-lo4ci
@VINAYKUMAR-lo4ci - 16.02.2022 16:01

Good

Ответить
@syedabdullah5259
@syedabdullah5259 - 12.01.2022 10:59

Thanks a lot

Ответить
@syedabdullah5259
@syedabdullah5259 - 12.01.2022 10:59

Very nice

Ответить
@KumarSingh-zc3iw
@KumarSingh-zc3iw - 23.12.2021 19:49

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

Ответить
@rajeevgosavi4514
@rajeevgosavi4514 - 16.10.2021 08:07

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.

Ответить
@marcelodelmastro8792
@marcelodelmastro8792 - 30.09.2021 04:47

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

Ответить
@maheshhadke14
@maheshhadke14 - 31.08.2021 08:58

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

Ответить
@sanofamotivation
@sanofamotivation - 04.06.2021 20:47

Thank you it was very helpful

Ответить
@ngujennifer3066
@ngujennifer3066 - 02.05.2021 04:35

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!

Ответить
@arunkumar-tt5wc
@arunkumar-tt5wc - 21.04.2021 08:36

Usefull video tq❤

Ответить
@dileepmaurya5632
@dileepmaurya5632 - 01.04.2021 14:27

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. 🙏🙏

Ответить
@FRANKWHITE1996
@FRANKWHITE1996 - 01.03.2021 16:33

great! thanks!!!

Ответить
@leebalaila4760
@leebalaila4760 - 16.02.2021 12:40

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

Ответить
@amazinggrace6927
@amazinggrace6927 - 31.01.2021 15:51

Thanks a lot, this saved me

Ответить
@skyblue2337
@skyblue2337 - 29.01.2021 21:22

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

Ответить
@leukas723
@leukas723 - 09.01.2021 06:00

I am trying this method but nothing happens.

Ответить
@wstibbs1
@wstibbs1 - 30.12.2020 20:31

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

Ответить
@nithikasn
@nithikasn - 13.12.2020 18:52

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

Ответить
@nithikasn
@nithikasn - 13.12.2020 18:49

Dear PK!

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

AWESOME!

Ответить
@iwantovani3727
@iwantovani3727 - 09.12.2020 06:13

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

Ответить
@smabdullahalmahmud8499
@smabdullahalmahmud8499 - 20.11.2020 09:41

Thank you so so mauch!

Ответить
@PawanYadav_the_professor
@PawanYadav_the_professor - 09.11.2020 22:22

THANKS !!!

Ответить
@manojkrishnan8461
@manojkrishnan8461 - 06.11.2020 13:35

Thank you so much

Ответить
@siaozam
@siaozam - 09.10.2020 08:03

best ever advise! was a mystery to me for ages

Ответить
@anuppatel5807
@anuppatel5807 - 02.10.2020 09:12

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

Ответить
@jithujoseph1324
@jithujoseph1324 - 07.09.2020 10:04

Thank you so much

Ответить
@gobisekaran5102
@gobisekaran5102 - 01.09.2020 14:12

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

Ответить
@Dilsehandsome
@Dilsehandsome - 25.08.2020 06:29

Thanks

Ответить
@elvisjmartis
@elvisjmartis - 23.08.2020 10:07

Thank you so much. It was really helpfull

Ответить
@Manojkalkere
@Manojkalkere - 18.08.2020 09:21

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

Ответить
@vaibhavdhanwate7182
@vaibhavdhanwate7182 - 23.07.2020 20:14

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

Ответить
@vipinkumar-le7yf
@vipinkumar-le7yf - 09.07.2020 18:34

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

Ответить
@harshar6458
@harshar6458 - 30.06.2020 09:14

thanks brother

Ответить
@ajaykumargupta8504
@ajaykumargupta8504 - 26.06.2020 09:34

Thanks

Ответить
@oddnumber8149
@oddnumber8149 - 03.06.2020 10:15

if you have 2-April-2020 doenst work

Ответить
@ramkumar-cv9hl
@ramkumar-cv9hl - 21.05.2020 16:55

Thankyou

Ответить