How to Convert Number into Word in Excel in Indian Rupees | Microsoft office Excel formula in Hindi

Рет қаралды 1,325,803

6 жыл бұрын

Learn Functions - How to Convert Number into Word in Excel in Indian Rupees | Microsoft office Excel formula in Hindi for version 2003,2007 and 2010.
Hello dosto, App sabhi ko malum haiki Microsoft excel ek electronic spreadsheet software hai jisme hum bahut sare functions ka use humare daily office works ke lye use karte hai.
Simple press key:
Alt+F11 key to open VBA Editor goto Insert menu and then select module.
Paste this code and save.
Save kana hai - save as type=Microsoft macro enable work...
Use =SpellNumber your cell address.
Download Source code file- goo.gl/e7D1Cg
Previous Computer Knowledge Series Videos:
1. Computer Mail Merge in Microsoft Office Word 2007 with Excel step by step guide in Hindi Expert Guide Trick Part - 2
• Video
2. How to Mail Merge in MS Word in Hindi - Step by Step Mail Merge Wizard in Microsoft word. What is mail merge in hindi? Create Mail Merge Letter, Envelopes and Labels simply you learn Mail Merge in depth in this video.
• How to Mail Merge in M...
Like us on facebook: / my-smart-guide-2654047...
For the latest tech news and reviews, follow, LIKE, SHARE and SUBSCRIBE.
You can send your opinion via the comment box or e-mail : vimala26life@gmail.com
Do you have a question about this video that you'd like us to answer? Tell us in the comments section below.
Wish You Success,
OM PRAKASH SUTHAR
Admin- My Smart Guide
Online Internet Marketing Expert
OPSBHL - my IT race - KIDCFG KHG
(MCA, BCA, PGDCA)
E-mail- ops_bhl.mca@rediffmail.com
About : My Smart Guide is a KZfaq Channel, where you will find most technological videos, Make money online guide in Hindi, New Video is Posted Everyday :)
Annoying Orange

Пікірлер: 1 400

@mukeshjuyal1149 5 жыл бұрын

Could u please tell me how we will apply this macros in whole excel mean to say that every time when we open new file there should be already applied this....

@luhitpanging9068 2 жыл бұрын

I am also facing this issue in a new excel file.

@PetLover_ 11 ай бұрын

Same Here's 😢..

@nandank101 6 жыл бұрын

Sir "Compile error" Syntax error aa raha hai, help me pls...

@sujeetvishwakarma1817 5 жыл бұрын

Dear sir, Can we convert number into word without using macros or we will apply macros in one sheet so can use this spell number formula in other sheet also.

@DLSNews 6 жыл бұрын

excellent knowledge sir ji.

@MySmartGuideNews 6 жыл бұрын

Most important thing. Thank you for your time and consideration.

@Rabahakhtar 6 жыл бұрын

My Smart Guide goood plz send me code sir..

@omprakashsingh1375 6 жыл бұрын

Notepad se jo formula le liye aap wo hamlog kanha se layege

@vinodkumardron 2 жыл бұрын

Happy to. ,. M

@mnp_music 6 жыл бұрын

Nice

@shaileshkmr786 6 жыл бұрын

ऐसा कोई methed बताइये जिससे हिंदी में शब्द में रुपये लिखे

@ranjeetverma369 6 жыл бұрын

Please send links visual basic code.

@bansalmotorcorporation1883 5 жыл бұрын

@discovery6055 5 жыл бұрын

Sir pl send code

@centerforcesecurityservice9486 4 жыл бұрын

Hi. Thanks for video. I'm not getting continued next work sheet. Please help me. 8547661094. Kerala. Vikraman (retd Arny

@mohitshri4516 4 жыл бұрын

Send me visual basic code

@scslawaghoghri5072 4 жыл бұрын

Please how to canvert number word with hindi word me

@40keshav 5 жыл бұрын

Thanks sirji for your kind information. feel very happy & waiting for your new videos on excel.

@ashishdharpure1545 6 жыл бұрын

Hi Brother , Thank you very much for your valuable video... It is really useful and must say you have explained in very easy way so as every one can understand and implement the same . I hope many you will come up with many more videos

@ranjeetverma369 6 жыл бұрын

Sir ye visual basic ka code Hi nahi mil raha hai .ise download karne ka koi Idea hai ki nahi ise .kaha se download kare

@himanshuaggarwal6349 6 жыл бұрын

ye code aap copy kaar sakte ha link discrition me ha

@maambey9033 5 жыл бұрын

link kaha hai

@umedparashar6322 5 жыл бұрын

@YOUR WELCOME Sir, please let me know, how a word file can be given password

@anilnakipuria6873 5 жыл бұрын

@YOUR WELCOME where is discription

@ghurahuprasadyadav3798 5 жыл бұрын

Yadi , Mobile me EXCEL use karte hai to ise kaise karenge . Please reply

@k2shorts382 5 жыл бұрын

Office excel download kijiye

@jitendrakhot634 4 жыл бұрын

Mobile pe ye nahi work karega sir.

@geetanjalibangera5822 5 жыл бұрын

Thank you so much sir for teaching this. This is helping me alot.

@navinmehta8721 5 жыл бұрын

nice video in simple & lucid manner. look forward to get more useful videos from you.

@rinkuthakur5434 6 жыл бұрын

plz give me page link/note pad file

@mahendersinghsonitopriya4687 6 жыл бұрын

Please give me note pad link

@maazahmed3583 6 жыл бұрын

U can scroll details and u can find the link Download course code

@surajsarma2266 5 жыл бұрын

Mujhe notepad file chahiye

@aruneshk.pandey2216 4 жыл бұрын

please give me notepad link

@shamimansari5356 3 жыл бұрын

@@aruneshk.pandey2216 4

@bharatgupta2858 5 жыл бұрын

Great Video. I learnt a new thing and made my life a bit better. Thanks a lot.

@RMSLIVELEARNING 6 жыл бұрын

very nice n helpful information thanks for sharing

@SapnaSingh-fv1ko 6 жыл бұрын

Thank u sir, I m searching this formula from long time, thank u so much

@princerihan5684 4 жыл бұрын

Sir Thank u very much. your video correct I am use your formula thank u so much. and keep going on this type video

@vikassharma-fe8qy 5 жыл бұрын

Thanks......I have done successfully, as per your instructions

@COMEDYKING01139 4 жыл бұрын

Sir g iam install the cord very well in my laptop. And it is work one time when we save. Then after is not work in my laptop? Why? Answer me please. My laptop is acer company.and excel 2007. Please reply

@hittolike6259 6 жыл бұрын

good sir aap nai baht amazing formula bataya and ease hi help karate rhena thanks sir

@alokray4326 6 жыл бұрын

very nice and within the simple method it very useful to us thank you sir for your kind valuable information.

@siddharthm57 5 жыл бұрын

Thank you sir, i m using laptop ,ur video help me alot

@VikashSingh7877 5 жыл бұрын

Thank you so much. I tried a lot of things on internet but none were working. thank u so much

@rajesjg 6 жыл бұрын

sir, please tell if we don`t want to spell point amount. (In invoice always need round off amount. So not required point amount)

@GauravSharmaAAPKA 5 жыл бұрын

Superb U are genius sir great bravo man

@ravikumar-vt2ri 5 жыл бұрын

Dear sir you illustrate in so easy way, thank you very much Sir

@Pankaj-Verma- 5 жыл бұрын

Thank you very much for your kind help !

@Bhagyeshkrishna1985 5 жыл бұрын

This very good formula. Sir Please share words to number converting formula

@darshan3417 5 жыл бұрын

Sir 1 excel file is damage. I try to open but is showing the workbook cannot be opened or repaired by Microsoft excel because it is corrupt.

@kashishtextile1383 5 жыл бұрын

THANK U SOMACH, THIS VIDEO HELPFULL

@999jilan 5 жыл бұрын

Sir how to open a large xml file in excel quickly as my colleague is doing this but he did not disclosing the secret. Plz reply.

@rajeevnegi495 5 жыл бұрын

How to special formatting for posting any doc and after save generation posting no Required working in any software

@pratikmor2028 5 жыл бұрын

thanks its working in my laptop. but hope it will work on office PC too

@Kanteshpatil 6 жыл бұрын

Its Helps me Thank you Sir Its too Good

@simitmishra4981 3 жыл бұрын

Very helpful. I also made little changes and converted to Euros.

@shivagamipillai8470 6 жыл бұрын

Thank u so much sir aapne jo link diya hai vo bhi mujhe mili or mene try b ki thank u sir

@brijmohanfitness4473 6 жыл бұрын

aaj tak jo v maine kiya o hua nhi... lekin aap ki method work kar gayi thank you sir

@sunilkumar-lu1kn 6 жыл бұрын

Thank you so much sir app ka ye video bohat aacha hai aap bohat achi trah samjhate hai thank you again

@binaysharma4493 5 жыл бұрын

Har workbook me coding file banana pad raha h Aisa nahi ho sakta ki ek baar code file banakar save kar de aur jo v workbook ho usme wo work kare?

@ptechpharmamachinery5133 5 жыл бұрын

wow super he video sir plz ye MS office word me he technique plz video banaye

@janhavinaik3738 4 жыл бұрын

Sir Kya ye F11 ki activity har ek bar alag alag sheet me calculate karni padegi.. Means is it a one time activity or varies for different excel sheets?

@ravindrasad4131 5 жыл бұрын

Sir The cold button on the computer keyboard can tell where it is and what it is Please comment

@snadupalli 4 жыл бұрын

THANK YOU SIRJI, LET US KNOW HOW TO INSERT THE RUPEE SYMBOL ALONG WITH THE SPELLNUMBER

@rahulkumarchaudhary3660 6 жыл бұрын

Hello sir I have a question that How to apply this formula in all excel sheet THAT whenever I Open excel sheet then this formula already applied

@agnihotri80 6 жыл бұрын

It's better if same is saved as excel add-in and can be shared with all.Thx for sharing

@anmolnotani6361 6 жыл бұрын

Ye chiz me bhot time se find kar rhi thi finally ..i got it

@Kajalrahulofficial47 6 жыл бұрын

Sir ....... Thank you so much........ I am really thankful to you...

@darshitchavda8264 5 жыл бұрын

Thank you it's awesome sirjee

@YT_yogie 6 жыл бұрын

Impressive formula Sir! Thanks to share this video. I've try it but only couple of things misses in my Office 2007 application after follow all steps as suggested by you as follows: 1. save as option is not available 2. amount get in words but space between there is now space between two digit word i.e. if the number is 26 then amount in no. came like TwentySix. actually it should be in form of Twenty Six. Please suggest the correction.

@saurabhbaradkar3290 5 жыл бұрын

Could you please create a video for how to write macro coding? And How to know the excel language?

@SukhdevSingh-oo6tx 5 жыл бұрын

Sir ye ek hi time krta h kya?? Excel ko close krke agar new sheet Lete h to phir formula ni aata . Plzz reply

@mohammedtareq5093 5 жыл бұрын

Nicely done,stay blessed

@dhirenfilmsindia 3 жыл бұрын

thankyou very much itana achha video banane ke liye

@nirajjani 5 жыл бұрын

thank you. I have subscribed to you channel.

@ganeshgore6795 5 жыл бұрын

Sir ms excel or ms word ka basic se lekar end tak ek video banayi ye thaki me ushe dhekar shik Saku apke video ka intazar karta Hu tanks

@anand26051975 6 жыл бұрын

Thank you very much sir ho gaya number to word bhai logo pura video dekho aor link sir share ki hai dhyan se dekho

@enoka1970 5 жыл бұрын

Thank you for the info and the visual basic formula. How to change it to Million. It is in Crores

@ajaysolanki73 3 жыл бұрын

Thank you Dost... I helped me. Specially that text file to copy formula. Thanks once again

@azazhusenjalali2133 5 жыл бұрын

Greay Dear it working. Thanks for uploading

@ruchapandya9338 5 жыл бұрын

It works perfectly ...Thank u so much

@joshikamlesh 6 жыл бұрын

tnx bro.... i want to create invoice on excel sheet which should automatically save as sheet 1 for bill no.1 & sheet2 for bill no. 2.........so on.if possible

@shaukatali2003 6 жыл бұрын

Sir sheet 1 mai data detail mai hai. Like A/C no, date, name, amounts, father name. Class, and 2nd sheet mai A/C no or amount hai. Question ya hai Kay mujh ko A/C no wise amount ko reconcile karna hai. Or amount ka difference bhi nikal lay.

@bapibehera5715 6 жыл бұрын

source code is working...xcllnt.... How to learn Excell VBA....the best tutorial help.

@ManishKumar-fw7gn 5 жыл бұрын

Hello Sir, May you please describe me that how to copy & paste from rows of one sheet to the column of other sheets.

@jaffarabdulla583 4 жыл бұрын

Very nice sir, very helpful. thanks ..

@sahilaktar9046 5 жыл бұрын

Wonderful video.. thanks Bhai .

@johnanthony9896 5 жыл бұрын

hi, i couldn't find the keys to work for Microsoft visual basic. plz help me to install the formula for number to words.

@bhagyapaakashaale 6 жыл бұрын

it works only for that particular time and not for every time. And if we do this in one file wil it applicable to every files.??????

@madhusudhan7838 6 жыл бұрын

Exultant sir , thank u very much .

@antaryamiacharya5657 5 жыл бұрын

In every work sheet this has to done or once.

@muradkhokhar2949 4 жыл бұрын

very nice information.... I want a guid from you sir, "How can we make master data sheet in excel.... when we insert new sheet automaticaly mastsheet data insert."

@AmolPatil-cd4rz 6 жыл бұрын

It's great & knolegeble vedio. I want another vedio

@jawedakhtar7682 5 жыл бұрын

Very nice sir, very helpful

@mainstay8633 6 жыл бұрын

Hi..Thank you sir.................it's very nice and easy .

@funny.education 6 жыл бұрын

Sir Awesome... Thank u

@bharataggarwal8837 6 жыл бұрын

Thanku sir for giving such formula

@Aakashsingh0420 4 жыл бұрын

hello sir my self akash singh i want to asking one question from you sir i want to enable excel formula this type sir mujhe excel me jaise(EP1=1),(NP1=1) KARNA chata hu to kya formula lagaye

@DataLearninghub 4 жыл бұрын

=right(cell_reference,1) And you can use flash fill also for this

@DurgeshKumar-mn4ul 5 жыл бұрын

Sir g bahut achi h aapki video plz vlocup ka use kase kare batana

@niteshvalecha8913 5 жыл бұрын

Hi, I like this Video. Thanks for this. But can we change the sentence pattern in this?? Like value is 730.80 By Formula its Rupee Seven Hundred Thirty Paise Eighty Only But I need to show : Rupee Seven Hundred Thirty and Eighty Paise Only

@YOGESHYADAV-ow1ro 6 жыл бұрын

thankuu sir ji

@praveenkr64 6 жыл бұрын

Nice video very helpful thank you

@BestSongCollecation 5 жыл бұрын

Good Morning sir Sir muje ye jo word likhe jate h sabdo me muje ye hindi me likhna h kese kerenge

@Littel_madhav208 6 жыл бұрын

Thanx its really very helpfull sir

@pankajtyagi7193 6 жыл бұрын

Hi sir please let me know , from where that note pad file came from where we copy the text ?

@mashooqraza5469 6 жыл бұрын

Namaste sir, Could you please send me that your MS notebook file to save in my excel for applying auto formula as you said this function is not installed in excel could you please send me that notebook file or provide me the link please I would be very thankful to you

@aryadigvijay 2 жыл бұрын

very nice sir and very help full please make video over Up State Government Salary Sheet Mangement for individual person

@manya_jaiswal 6 жыл бұрын

Sir save Karne per Privacy Waring show Kar raha h this document cannot macros ,activeX controls,XML expansion pack information,or web component.These may include personal information that cannot be removed by the Document Inspector.

@jiwanmandlik2994 5 жыл бұрын

not done while debuting the visual coding comiple error shows with some other difficulties

@ravikumarprajapati7275 4 жыл бұрын

THANK YOU SO MUCH

@manjubaghel8846 5 жыл бұрын

thank u

@surenu1782 6 жыл бұрын

very important and useful information

@ganesharaam8071 5 жыл бұрын

Thank u!

@madhurarane7685 5 жыл бұрын

Was very helpful.

@mukeshone99 5 жыл бұрын

Sir, Excel mein indian rupees ki style mein commas laane ki koi remedy hai ? As e.g. 11,34,67,783.64 English style mein aaisa nahi aata hai Please guide me

@gpnewsmyd9604 6 жыл бұрын

Nice video sir....Thank u

@shreekrishnaengineering906 4 жыл бұрын

Sir. In last video i copy the module code and save it...but after making total and giving formula again that page is getting open Microsoft visual basic

@amiyaranjanrana6750 6 жыл бұрын

Sir ji this technique is awesome

@surajkumar-hu2vw 5 жыл бұрын

sir this formula works for same sheet means in which we had put formula but in another file, it does not work. pl. guide.

@MySmartGuideNews 5 жыл бұрын

Sir ji file Ko macro enable mode me save Karen.

@avneeshpandey 6 жыл бұрын

Sir ye btaiye ki mere laptop me setting krne ke baad shabdo me change ho jata hai Pr agar dubara se excel close l Krke aur phir se open krte hai to wo function hat jata hai kyu Ya phir jitni baar krna ho utni baar ye kaM krna pdega