Convert rupees into text in excel | with step wise tutorial
524 views · Published 28 January 2018 · 4:53 · Indexed 12 November 2026
Channel: MCi Tech · 2018 · Education
Hello everyone , In this video you can learn convert number/Rupess into text/word in Ms excel workbook simple and easy step wise tutorial Step 1 - Create new Blank Excel sheet Step 2 - Go to Internet Explorer - Open Google ------ Step 3 - Type convert rupees into word in excel Step 4 - click link - Excel function to convert Rupees in figure to Rupees in word Step 5 - Given there SpellNumber module function select the code line. Step 6 - Right click the mouse -click copy- then close the web page Step 7 - Go to Excel workbook Step 8 - Click Developer tab-from menu bar - if not showing in menu bar then Right click in the menu bar Step 9 - Click Customized Access Toolbar Step 10 - Click Customized Step 11 - Choose Command from - Click Developer tab Step 12 - Click Visual Basic Step 13 - Click Add- Click OK Step 14 - Then Visual Basic editor will be display in menu bar Step 15 - Launch/Click the Visual Basic editor Step 16 - Click Insert menu - click Module Step 17 - Paste the formula (copy from Google) Step 18 - Click Save Step 19 - Type file name Step 20 - Select Save as type - Excel Macro Enabled Workbook Step 21 - Click save after that Step 22 - Click required cell - type =SpellNumber left hand bracket cell address right hand bracket close Step 23 - Press enter Finally converted the number/amount into text/word Than you
More from this channel
-
10:44
how to create table in ms access steps | Part-1
-
2:47
How to change folder icon with PNG file using MS Paint | without Converter s/w
-
4:55
How to use PMT function in excel WITH EXAMPLE | PMT Financial function
-
12:22
How to make Your Own Book cover using MS word 2007
-
13:08
Attach video file to an Access Database
-
8:40
creating, saving Barcode - using Barcode Generator Software Part2
-
11:12
Auto Result Sheet in Excel
-
20:13
How to create Logo in ms word Part 3