#shorts

#Shorts , this is a simple trick to convert text into number format in excel. you can simply use *1 and your text will be get converted into excel and will save lot of time.
download link :- drive.google.com/file/d/1jSQX...
*********FOLLOW ON*************
Facebook :- / excelworldofknowledge
Twitter - / sohandey3
Follow me on Instagram :- / sohandey_got
______________________
Excel formula
How to use index match formula from Basic to advance :- • index match excel || H...
How to make big formula in excel in hindi :- • combination formula ||...
Xlookup and Filter formula in hindi :- • Xlookup for Free || Ne...
How to reduce excel file size :- • compress excel file ||...
How to use Xlookup in excel :- • How to use Xlookup in ...
xlookup formula in hindi :- • How to use Xlookup in ...
array function in excel :- • Array formula excel ||...
New Xlookup with Search Mode :- • xlookup in excel in hi...
Xmatch formula in excel in hindi :- • Xmatch formula in exce...
how to use filter formula in excel in hindi :- • filter formula in exce...
Excel formulas and functions:- • Top 10 excel formulas ...
How to use excel unique function:- • How to use excel uniqu...
Sort formula in excel :- • Sort formula in excel ...
Gyan On Tube Excel

[@Munshifactbhaiyya]

Es video se mujhe bahut help mili bahut bahut dhanyawad aapka

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@srijeshtparambath731]

We could try by enter Alt D E F ☺️

[@GyanOnTube]

Please try if that works

[@user-ht9ts9ji1y]

Thanks 🙏

[@RubelKhan-bf1mx]

beautiful sir

[@GyanOnTube]

Thank you so much..do not forget to share this video for better reach

[@bbalunaik5935]

Beautiful,sir

[@GyanOnTube]

Thank you so much

[@SachinKumar-we2we]

Wow great trick sir❤️

[@GyanOnTube]

Thank you so much

[@Cricketshorts009]

Perfect! If data is huge then it takes lot of time to convert text data into number through that old style....will definitely gonna try this and also will share it to my friends 👍

[@GyanOnTube]

Thank you so much...🙏🙏🙏

[@sanjibpatro5863]

Instead u can use alt+d+e+f... It works perfectly

[@pankulbaijal7542]

Good one. 👍 👍

[@GyanOnTube]

Thank you

[@Exceltrick4u]

But agar same column mein krna hai to bhi ho jayega text to column se, Alt+A+E

[@AnkitVerma-cn3px]

Yup

[@GoodBoy-tp9pi]

Exactly

[@htsabdul786]

Thanks

[@towhidzzzzz5050]

Thanks bro

[@tallurirubiearpanabhilash9581]

Thank you so much

[@GyanOnTube]

Thank you so much..fo not forget to share this video

[@bharathbharath2362]

U can use by selecting total column and alt, D,E and enter. Even 50000 rows also easily it works

[@AnantKumar-]

Useful information. But I'm struggling with date

[@GyanOnTube]

Tel me your issue

[@AbidAli-dx8tg]

Superb ❤

[@GyanOnTube]

Thank you so much

[@excelclub9282]

Nice sir

[@GyanOnTube]

Thank you so much..

[@rohankolhe7492]

💯💯💯👏👏

[@GyanOnTube]

Thank you so much

[@nishhhanchan]

Thank you so much brother it works 🤗🤗🤗

[@GyanOnTube]

Thank you so much 🥰

[@mohansahu4286]

Copy a blank cell.... select text cells...right click...go to special....add... done

[@poojashukla6119]

Superb sir ❤️

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@kailaschaugule1398]

Thank you....

[@GyanOnTube]

Thank you

[@arijeetkumarsharma226]

Superb.

[@GyanOnTube]

Thank you so much..

[@sachindrasinha74]

Beautiful trick

[@GyanOnTube]

Thank you so much..

[@AnilKumar-gq9hs]

Thanks mai bahut pareshan ho gaya tha

[@GyanOnTube]

Thank you so much

[@bikashbantawa7873]

❤❤❤

[@GyanOnTube]

Thank you so much

[@khalidalisubhanallah2947]

Nice 👍 video

[@GyanOnTube]

Thanks

[@99100sam]

Thanks

[@GyanOnTube]

Thank you so much

[@unlimitedGK-om8bs]

🙏🙏🙏 spectacular

[@GyanOnTube]

Thank you

[@pankajsaini50]

Nice info

[@GyanOnTube]

Thank you so much

[@accountantrajatsharma2992]

Great

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@pagidojusairam7615]

Superb bro 👌👍

[@GyanOnTube]

Thank you so much

[@harbindersinghjolly8398]

thank you so much

[@GyanOnTube]

Thank you so much

[@vanivani3841]

1st number 0 after use sum function

[@GyanOnTube]

Happy learning

[@tarang0016]

Ye wala bahot useful tha.. i wasted lots of time on this

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@user-ht9ts9ji1y]

Bhai Alt+D+E+F use 😊

[@Dev_Saharan7715]

Thank you 🙏

[@GyanOnTube]

Thank you so much

[@sabeenabanoraein3339]

Good

[@GyanOnTube]

Thank you so much

[@amarjavir1500]

Very nice

[@GyanOnTube]

Thank you so much

[@supakarnishank8]

Helpful

[@GyanOnTube]

Thank you so much

[@afsar0066]

Alt+Def karau hoojainga number mai

[@AbdulKarim-um6bk]

Ty man

[@vinitjain6340]

U can use Alt + D+E

[@GyanOnTube]

Sure you can

[@sinister534]

How to add green triangle

[@GyanOnTube]

Means

[@sanjibpatro5863]

Alt+d+e+f... This shortcut can be used

[@kavyarenesme9837]

Thank you so for this shortcut. I was really struggling with it❤

[@GyanOnTube]

Happy learning

[@cooldev2342]

Nice

[@GyanOnTube]

Thank you so much

[@ilakkiyas8590]

Sir i mentioned numbers with quantity symbol like 12 kg, 11 nos,10 pcs now i need to change this into numbrs like 12 , 11, 10 only instead of using quantity symbol can u plse tell me how to do it ?

[@GyanOnTube]

Go to custom setting and just put #

[@arpitbansal2477]

We can also use "int" function to do the same thing.

[@GyanOnTube]

Sure you can definitely try

[@PRAVESHKUMARYADAV]

Pahle se hee numbers me hai

[@GyanOnTube]

Please check again

[@prataprana9194]

Bhai Hindi data ko siqvance me kaise lagaye

[@GyanOnTube]

Means???

[@rishabhp90]

How to reverse this, number to text again?

[@GyanOnTube]

I have already prepared a video for this..you can watch that

[@technicalas8335]

Sir reverse function keyse karu ( text to number convert)

[@GyanOnTube]

Already video hai uski bhi..check that one

[@technicalas8335]

@@GyanOnTube link please

[@WorldViralVideo4]

Ist isme Text kha the 2 Text row me green kya tha ?

[@GyanOnTube]

Means..??

[@WorldViralVideo4]

@@GyanOnTube 46060 me corner me green ka kya matlab hai ?

[@tusharsharma7664]

Can we use Value function?

[@GyanOnTube]

Try it once

[@PraveenKumar-sv5xh]

Sir excel se date mail merge karte hai toh ushka format number mein convert ho jata hai. Please hlp

[@GyanOnTube]

To aapko uska format text mein hi rakhna hai kya

[@ghulammustafachachar6541]

Menu bar s hm n form ka option lagaya thah ab wo hatana chahten wo to plz btao kesy haten

[@GyanOnTube]

Means

[@dharmendrachaurasia1080]

How to make graph on exel.

[@GyanOnTube]

I have prepared videos on that as well..you can check on my youtube channel

[@techtalk4243]

Ye to pehle se number mai hi hai

[@GyanOnTube]

Check the format at the top it is not in number

[@Aastha_Bhakti]

Excel 2007 me nahi ho raha

[@GyanOnTube]

This will not work in office 2007

[@ankitkushwaha6225]

Text kise kahte aur number kise kahte ? Plz tell me

[@GyanOnTube]

Uske liye mene ek video bana rakhi hai mere channel mein aap waha jaake dekh sakte hai

[@GoodBoy-tp9pi]

@@GyanOnTube link de na Bhai,

[@ishorbista4838]

this is not helpful😢😢

[@GyanOnTube]

Why

[@zohraankhan3131]

Text kider hai bhai uder?

[@GyanOnTube]

Check once again

[@jeetunama473]

Alt+AE bhi work karta hai

[@GyanOnTube]

Ok nice

[@miileeuko143]

Date ko kaisy krin

[@GyanOnTube]

Kya karna hai date ka aapko

[@miileeuko143]

@@GyanOnTube brother mary pass sheet hy uski date formate kr kr thak chka.hn.....formula trick hr harba azma chuka hn but text date number min convert ni hoti....apki. ideo sy motivate hork commnt keya hy apko or ap kehty hain date ko kah krna hy

[@GyanOnTube]

Aapko number date format mein karna hai kya..uske liye mene ek video already published kari hui hai..aap check kar sakte ho

[@miileeuko143]

Link plz

[@reenajoshi2108]

How to convert number to text

[@GyanOnTube]

Same method

[@alamgir178]

Mobile 📲 kesa lekigge

[@GyanOnTube]

Apply same logic in mobile as well

[@alamgir178]

Mobile no a kesa zero lekega

[@ishikashah9160]

essa kyuu hota hai

[@GyanOnTube]

Kesa 😊

[@jswntsr]

Great

[@GyanOnTube]

Thank you so much