Sir Number to text video dekha bahut achchha laga aur maine sikha bhi. Ek request hai k aap date ko word me convert karne ka video banayen please help me.
Even if this one is working but for official use its not useful for many users as many banks, insurance offices does not allow users to access Internet sites as they only use intranet for office use only..
Wonderful teaching atleast for day today usage home or business front. We shouldn't forget there are multiple ways of doing an act in MS office but a teacher is presenting info unheard, unseen not thought with ease even for a layman. Regards
Gr8. I have devised a formula for such a function, which works for decimals also. No need for any spreadsheet/ extension bla bla. Just copy and paster the formula in desired cell nd u will get the result. Can send the formula if anybody needs.
Some amazing people like you are making such kind of useful and interesting videos for people to learn. really thanks a lot. keep it up. Thank you brother.
Lets suppose we have a list with 1 colomn named as (students) and 2 column named as (ID) and i want that the names in student column will show some custom error if ID column is blank how can i do that?
Thank you sir..Apki is video se meri kaafi help ho gyi isliye I am subscribing to your channel.
Thank you so much..do not forget to share this video
Bahut acha tricks hai sir🙏
Maine abhi tak coding ke thorugh text to number convert karta tha
Thank you so much..do not forget to share this video
Thanxs a lot dear last sometimes i can search this formula but finally i give by you.
Thank you so much 🥰
Very nice tricks
Thank you so much..do not forget to share this video
=a simple spellnumber() formula will do it. 🤷🏽♂️
Do we have spellnumer in excel..??
I am very well versed with vba coading..but every one is not familiar with vba..thats why i prepared this..😊
@app info bro can you share a video for vba one I am unable to find a video which works for me
Sir it's very useful for me... please make a video on how to convert an excel sheet into XML format without VBA coding
Sure will do that..thanks for your comment
Waah waah👌
Thank you so much..do not forget to share this video
Great Tip and shortcut. Its really useful for excel lovers...
Thank you so much..do not forget to share this video
Thank you Sir. It's very good video. ❤️❤️❤️❤️
Thank you so much..do not forget to share this video
Sir
Number to text video dekha bahut achchha laga aur maine sikha bhi.
Ek request hai k aap date ko word me convert karne ka video banayen please help me.
Nice suggestion..sure will make a video on that as well
Excellent
Thank you so much
Even if this one is working but for official use its not useful for many users as many banks, insurance offices does not allow users to access Internet sites as they only use intranet for office use only..
For that ill prepare one more video which will help banks and all..
Sir, I am regular follower of u
Thank you so much 🙏🙏
Superb
Thank you so much..do not forget to share this video
Good sir mazza aageya
Thank you so much
Bhout maja aya ♥️♥️♥️
Thank you so much 🥰..do not forget to share this video
You earned my subscribe!!. Great job
Thank you so much..do not forget to share this video
Thnkss alot
Thank you so much
thank you Sir for useful information ♥️
Thank you so much..do not forget to share this video
Thanks sir nice 👍👍
Thank you so much
Good sir
Thank you so much
Dear sir your voice is very sweet ❤
Thank you so much 😊
Thanks for sharing the trick but, in my opinion Excel VBA is the best option
In excel we have many options to do one activity
kindly tell us the vba code
Please help how to use vba
Ok sure ill prepare a module for this very soon
Bhai kam karta hai ......😎🤘👍
Awesome 👍
Very easy and good
Thank you so much
Very informative
Thank you so much..do not forget to share this video
This channel is surely underrated. Jitni mehnat aap kar rahe hai, aap pakka successful honge.
Thank you so much... appreciate your support 🙏🙏
thanku sir...
Is it safe for data privacy as it has been done using online method??????
Absolutely safe..this is google sheet and you can only open google sheets of you are logged in with your email..so this is 100% safe
Wonderful teaching atleast for day today usage home or business front. We shouldn't forget there are multiple ways of doing an act in MS office but a teacher is presenting info unheard, unseen not thought with ease even for a layman. Regards
Thank you so much
below 100000 convert hote hai.....above k liye use ful nahi hai...
Excellent thanks
Thank you so much..do not forget to share this video
Ye awwsm tha sir💯💯💯🌟
Bahut bahut shukriya
@@GyanOnTube 0
Great work sir
Thank you so much
Thanks Sir
Thank you so much
Thank you Sir amazing
Thank you so much..do not forget to share this video
Amazing 👌
Thank you so much.. please do not forget to share this video
Bohut sahi sir
Thank you so much
Thank you sir is amazing trick ke liye, main ne number ko text me convert kiya hai formula use karke, par mujhe ek din lag gaya ye karne me
Yes you can apply through this trick
I am your new subscriber
Thank you so much
Thank you very much sir
Thank you so much..do not forget to share this video
Nice Tip. How to make text in proper casing?
Can please show me an example
@@GyanOnTube I mean how to make the text properly,
ex: instead of eight hundred fifty, it should say Eight Hundred Fifty.
Use proper function on final result
@@GyanOnTube Got it, Thank you so much.
Nice
Thank you so much
Good
Thank you so much..do not forget to share this video
Very useful
Thank you so much
Wow😲 👌👌👌 Magic Amazing Sir
Thank you so much..do not forget to share this video
Thank you sir
Thank you so much
Wah bhai amazing 🤩🤩 Thank u brother
Thank you so much..fo not forget to share this video
Gr8.
I have devised a formula for such a function, which works for decimals also. No need for any spreadsheet/ extension bla bla. Just copy and paster the formula in desired cell nd u will get the result. Can send the formula if anybody needs.
Unable to understand your question.. please elaborate again
Please send the formula
Yes
Change Number To Rupee Word very easy way -
th-cam.com/video/-jDT0sOGyA0/w-d-xo.html
Hello Sir ummid h aap khair se honge…
Sir mera ek question h aap se ke ek smart monthy budget sheet with margin business k liye kaise banayen???
Iske liye mujje data chaiye mein aapke liye video prepare kar dunga
Appreciate sir
Thank you so much
Mind blowing
Thank you so much..do not forget to share this video
@@GyanOnTube mene aaj hi aapka channel subscribe kiya h, aapki kuch videos dekhi, aapki voice bahut achchi h,
Thank you so much..🙏🙏🙏
@@GyanOnTube excel me format me custom me # hashtag ka kya use hota h
Jese 0" Pcs" Likhne k baad, sabhi number k aage pcs aa jata h
Wo aap custom formatting ke through kar sakte ho
Simple method:
Open any working wordfile
Alt+F11
Ctrl+G
ActiveDocument.ConvertNumbertoText
And
Alt+Q
Can you please elaborate more..
@@GyanOnTube Please give me your email, I have send some screen shot....
Helping video
Thank you so much..do not forget to share this video
Welldone
Thank you so much
Thanks a lot. Till date I am using VBA code for this function. It's so helpful. Please post such hidden gems if Excel..
Thank you 😊 so much..do not forget to share this video
Change Number To Rupee Word very easy way -
th-cam.com/video/-jDT0sOGyA0/w-d-xo.html
Very nice
Thank you so much
Good Work
Thank you so much
Fantastic
Thank you so much 🥰
Very useful trick! HC ARORA Vaishali Ghaziabad UP
thank you so much ! Best of luck
Baoo sir grateful video
Thank you so much..do not forget to share this video
👍👍
Thank u sir this information is very useful. pls upload more excel videos thank u......
Sure will do that for sure...do not forget to share this video 🙏
@@GyanOnTube definitely i share this who needed sir
Good sharing
Thank you so much..do not forget to share this video
Thanks
Thank you so much
Great trick ❤️
Thank you so much
sir thanks for this help but when i did in decimal number ..its showing problem at decimal digit ..kindly help for this problem
Ok np at all..will prepare one more video for that..thanks foe informing
Another addon Spellvalue will help you in this.
Ok sure
Sir, once create IT challan 280 or 281, which needs convertion of number into figure once, not many times.
For that you need to apply macros
This add on can added in Excel as well
Great..got for it then 👍
Useful
Thank you so much..do not forget to share this video
Bhai mere working professionals Google access nahi kar sakte unke company laptops par. Pls share options of ms excel only
For sample sheet you can download from world economic outlook database
@@GyanOnTube pls share direct excel formula
Good evening sir
Very good evening..🙏🙏
Nice 👌👌
Thank you so much..do not forget to share this video
Is this will work in Google sheet app in android smart phone?
Yes definitely it will work
Awesome Sir
Thank you so much..do not forget to share this video
@@GyanOnTube Sure Sir definitely i will do it as i m biggest fan of your youtube videos on excel and powerbi
Thank you so much 🥰
Hii sir, ek br download hne ke baad phirse download krna pdta hai agar ek aur file ke liye hum ko number to text krna hai to
Hanji ek bari mein ek hi worksheet mein work karega
good sir
Thank you so much 🥰
Some amazing people like you are making such kind of useful and interesting videos for people to learn. really thanks a lot. keep it up. Thank you brother.
Thank you so much...do not forget to share this video and thank you for your support 🙏🙏
@@GyanOnTube 😂q😂
kam k chiz, thank u
Np.. thank you so much 🥰
Morning Sir. Sir , How to perform this action on desktop ?
Apply same steps into desktop
Kya aap date of birth ko word me convert kar sakte hai .... In word document example..in figure 5/5/2010 ko word me fifth may two thousand ten
Nice..sure will make a video on this as well
amazing information
Thank you so much..do not forget to share this video
nice
Thank you so much..do not forget to share this video
Sir please start a paid workshop and take live session with each day plan
Very nice suggestion...will definitely look forward for that..🙏🙏
@@GyanOnTube I'll be the first one to join
Thank you so much
how to convert numbers in indian number system in hindi i.e. 123-एक सौ तेईस
Nice question..i will prepare a video for that as well
Sir iske last me indian rupees ka name bhi aana chahiye....As 25- twenty five rupees. uska koi solution batao....
Ek cell mein indian rs rakh do aur concate kar do dono column ko
Thank you🙏🙏🙏🙏🙏
Thank you so much..do not forget to share this video
Appreciate your effort. 👏👏👏👏
Thank you so much..do not forget to share this video
How to remove 3 decimals in excel
Example
before 2500.105 * 2
After 2500.11 * 2 = ans as per 2 digit
Do custom formatting
But the result is not coming gas per India numbering .. is there any option to convert to India method
Foe that we need to apply a small macro as well
I have one doubt regarding which formula is to be used for which condition ? Pz advice
For this you need to pratice and with experience you will get to know
@@GyanOnTube but how can I practice without knowing which formula to use & when ?
For that only we need to pratice again and again
@@GyanOnTube Thanks for your reply. Can u plz suggest some source for getting raw data to practice advance excel ?
Power BI part 2
Sir iske liye internet ki jarurat hogi Kya
Hanji bilkul hogi
M using excel mobile any solutions bro
On mobile we do not have such options as of now
I think its have a problem when we install number text.Because we shared our privacy unknown source.
Are you using in you office laptop
How to Use Macros.. Please Define..
Sure will prepare a video for that as well
There are plenty of websites doing it. They're quicker than this method.
Happy learning
Lets suppose we have a list with 1 colomn named as (students) and 2 column named as (ID) and i want that the names in student column will show some custom error if ID column is blank how can i do that?
Yes you can create 3rd helping column and apply if condition
@@GyanOnTube how i need some vedio tutorial please or formula
Sure will do that
@@GyanOnTube then metion me on that vedio or send me a link
Sirji ye data privacy and data integrity ko violate krega
Ye home use ke liye hai
Sir kya ye option Directly Excel mey use kar sakte hai
Means
@@GyanOnTube bina Google sheet ke help liye
Ok use liye hum chota sa macro bhi laga sakte hai
Excel mey Number to word converter for mobile version
Sure isliye liye mein video prepare kar dunga
Can i used it on excel web online
As of now yes..but you can download the excel file after your data is converted
@@GyanOnTube thnx let me try
It's a lengthy process. Better, one time copy VBA code and use it whenever you want with the =spellnumber( ) formula.
Every one is not aware of vba...so this is excel trick
*I am still unable to understand that why Microsoft Excel does not provide "Number To Text" feature.*
You just need to add an addin