#shorts
HTML-код
- Опубликовано: 19 авг 2024
- #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.c...
*********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
Es video se mujhe bahut help mili bahut bahut dhanyawad aapka
Thank you so much..do not forget to share this video
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 👍
Thank you so much...🙏🙏🙏
Instead u can use alt+d+e+f... It works perfectly
U can use by selecting total column and alt, D,E and enter. Even 50000 rows also easily it works
We could try by enter Alt D E F ☺️
Please try if that works
Thanks 🙏
Wow great trick sir❤️
Thank you so much
But agar same column mein krna hai to bhi ho jayega text to column se, Alt+A+E
Yup
Exactly
Thanks
Thanks bro
Thank you so much
Thank you so much..fo not forget to share this video
beautiful sir
Thank you so much..do not forget to share this video for better reach
Good one. 👍 👍
Thank you
Beautiful,sir
Thank you so much
Ye wala bahot useful tha.. i wasted lots of time on this
Thank you so much..do not forget to share this video
Bhai Alt+D+E+F use 😊
Superb ❤
Thank you so much
Copy a blank cell.... select text cells...right click...go to special....add... done
Thank you so much brother it works 🤗🤗🤗
Thank you so much 🥰
Thank you....
Thank you
Beautiful trick
Thank you so much..
Nice 👍 video
Thanks
Thanks mai bahut pareshan ho gaya tha
Thank you so much
Useful information. But I'm struggling with date
Tel me your issue
Superb.
Thank you so much..
Nice sir
Thank you so much..
thank you so much
Thank you so much
Superb sir ❤️
Thank you so much..do not forget to share this video
Thank you 🙏
Thank you so much
Nice info
Thank you so much
🙏🙏🙏 spectacular
Thank you
Great
Thank you so much..do not forget to share this video
Very nice
Thank you so much
💯💯💯👏👏
Thank you so much
1st number 0 after use sum function
Happy learning
Superb bro 👌👍
Thank you so much
Thanks
Thank you so much
Good
Thank you so much
Helpful
Thank you so much
Alt+Def karau hoojainga number mai
Ty man
We can also use "int" function to do the same thing.
Sure you can definitely try
U can use Alt + D+E
Sure you can
How to add green triangle
Means
❤❤❤
Thank you so much
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 ?
Go to custom setting and just put #
Bhai Hindi data ko siqvance me kaise lagaye
Means???
How to reverse this, number to text again?
I have already prepared a video for this..you can watch that
Nice
Thank you so much
Alt+d+e+f... This shortcut can be used
Thank you so for this shortcut. I was really struggling with it❤
Happy learning
Sir reverse function keyse karu ( text to number convert)
Already video hai uski bhi..check that one
@@GyanOnTube link please
Ist isme Text kha the 2 Text row me green kya tha ?
Means..??
@@GyanOnTube 46060 me corner me green ka kya matlab hai ?
Sir excel se date mail merge karte hai toh ushka format number mein convert ho jata hai. Please hlp
To aapko uska format text mein hi rakhna hai kya
Can we use Value function?
Try it once
Text kise kahte aur number kise kahte ? Plz tell me
Uske liye mene ek video bana rakhi hai mere channel mein aap waha jaake dekh sakte hai
@@GyanOnTube link de na Bhai,
How to make graph on exel.
I have prepared videos on that as well..you can check on my youtube channel
Menu bar s hm n form ka option lagaya thah ab wo hatana chahten wo to plz btao kesy haten
Means
Alt+AE bhi work karta hai
Ok nice
Date ko kaisy krin
Kya karna hai date ka aapko
@@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
Aapko number date format mein karna hai kya..uske liye mene ek video already published kari hui hai..aap check kar sakte ho
Link plz
Excel 2007 me nahi ho raha
This will not work in office 2007
Pahle se hee numbers me hai
Please check again
Text kider hai bhai uder?
Check once again
Mobile 📲 kesa lekigge
Apply same logic in mobile as well
Mobile no a kesa zero lekega
How to convert number to text
Same method
Ye to pehle se number mai hi hai
Check the format at the top it is not in number
essa kyuu hota hai
Kesa 😊
this is not helpful😢😢
Why
Great
Thank you so much