Convert rupees into text in excel | with step wise tutorial

523 views · Published 28 January 2018 · 4:53 · Indexed 20 September 2026

Channel: MCi Tech · 2018 · Education

Watch on YouTube

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