Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples)

[@HiroshimaMS]

I'm 10 years behind in my knowledge lol it was exactly what I was looking for and much more and very well explained on top of that. Thanks a lot!

[@excelisfun]

Glad this helps!!!!

[@FsoOmar]

Thank you very much Mike. The basics you taught 6 years ago, are still applicable today.

[@excelisfun]

Yes they are!

[@excelisfun]

Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples)

[@excelisfun]

William San, your Google settings disallow commenting on your comments. Here is a formula that may do what you want: =TEXT(A2,"0000-00-00 00\:00\:00")+0 Where A2 has the value: 20140212115156

[@Rohitkumar-wk2vo]

Can't believe this video uploaded 8 year ago.

[@excelisfun]

Still great today. I have posted more than 20 different classes here at KZbin, but the videos in this 2013 class are by far the most detailed and complete ever. The one on PivotTables is the most detailed video that I ever made.

[@HiroshimaMS]

@@excelisfun Pivot tables? I must see that right away! If you explain it like you did in this video I will finally understand how to update pivot tables!

[@zm2813]

Thanks a lot for sharing this!

[@sandeepkothari5000]

Mind blowing!

[@excelisfun]

Glad you like it, Sandeep!!!! Thank you for your support : )

[@williamsan2213]

how can I put value 20140212115156 to convert into display YYYY-MM-DD HH:MM:SS?

[@iziaurrahman]

too good mate!

[@nak460]

hi Sir, that's great , but if i want to convert 5,000.00 by just type 5 so how can i do

[@vvolfbelorven7084]

Is Flash a sort of formula or something?

[@MrSarky1992]

Hey, Another possible solution for getting Last name only: =RIGHT(A36,LEN(A36)-SEARCH(" ",A36)) That's nice as well.

[@alexsandor4673]

Hello Michael. I just found your channel, and I want to download the workbooks, but the link is unavailable. Can you help me to get those?

[@excelisfun]

I just checked, the links are working.

[@alexsandor4673]

@@excelisfun I tried to open the link from my phone & my laptop, but it says that the page took too long to respond, and when I do an internet scan, it says the page isn't working...

[@excelisfun]

@@alexsandor4673 Must be on your end. The web site is working on this end.

[@alexsandor4673]

@@excelisfun I also tried to download a file that is 4 years ago, but it's the same problem. maybe it's my region? but I don't think so...I'm from Europe if it can be a problem.

[@alexsandor4673]

@@excelisfun maybe you have a solution or something? it will be awesome if you maybe can help me with an solution...

[@anil11996]

great wow...........

[@excelisfun]

Glad you like it!

[@genofgod]

ExcelIsFun I have a question. Why whenever I try to custom format a credit card number to XXXX #### XXXX #### the last numebr always changes to a zero. How can I write the format to stop that from happening? Please assist