#shorts | convert text into number format in excel in Hindi magic trick

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

**********FOLLOW ON**************
______________________

Excel formula

Gyan On Tube Excel

[Munshifactbhaiyya]

Es video se mujhe bahut help mili bahut bahut dhanyawad aapka

[Exceltricku]

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

[Cricketshorts]

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 👍

[AnantKumar-]

Useful information. But I'm struggling with date

[nishhhanchan]

Thank you so much brother it works 🤗🤗🤗

[mohansahu]

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

[bharathbharath]

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

[WorldViralVideo]

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

[technicalas]

Sir reverse function keyse karu ( text to number convert)

[rishabhp]

How to reverse this, number to text again?

[ilakkiyas]

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 ?

[PraveenKumar-svxh]

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

[prataprana]

Bhai Hindi data ko siqvance me kaise lagaye

[tarang]

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

[ankitkushwaha]

Text kise kahte aur number kise kahte ? Plz tell me

[arpitbansal]

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