How To Write Indian Currency In Words In Excel
Type INR Symbol in Word. Click on Module under the Insert menu as shown below.
How To Convert Number To Words In Excel
Save this code and go back the worksheet in a blank cell enter this formula SpellNumberToEnglishA2 A2 is the cell you want to convert the number to an English currency word and then drag the fill handle down to the cells that you want to apply this formula all the numbers have been spelt out into English currency words see screenshot.
How to write indian currency in words in excel. Open a new workbook. Press Alt F11 It shows like Insert -- Module. However if you want to use Rupee symbol in Excel 2010 there is a simple way than that.
Goto the Control panel and select the Region and Language button. Do the same on the Currency Tab and Apply. If DecimalPlace 0 Then Paise GetTensLeftMidMyNumber DecimalPlace 1 00 2 MyNumber TrimLeftMyNumber DecimalPlace - 1 End If myCrores MyNumber 10000000 myLakhs MyNumber - myCrores 10000000 100000 MyNumber MyNumber - myCrores 10000000 - myLakhs 100000 Count 1 Do While myCrores Temp GetHundredsRightmyCrores 3 If Temp Then Crores Temp PlaceCount Crores If LenmyCrores 3 Then myCrores LeftmyCrores LenmyCrores.
How to Convert Number to Word in Excel in Indian RupeesHindiIn this short tutorial you will learn excel functions by creating a responsive Sales and Accoun. How To Create SpellNumber Indian Rupees Function. A blank module sheet will open.
Hold down the ALT F11 keys to open the Microsoft Visual Basic for Applications window. You can easily insert rupee symbol in excel spreadsheet by choosing the currency symbol rupee in the format tab. Convert Paise and set MyNumber to Rupee amount If DecimalPlace 0 Then Paise GetTensLeftMidMyNumber DecimalPlace 1 00 2 MyNumber TrimLeftMyNumber DecimalPlace - 1 End If Count 1 Do While MyNumber If Count 1 Then Temp GetHundredsRightMyNumber 3 If Count 1 Then Temp GetHundredsRightMyNumber 2 If PlaceCount Then If Temp Then Rupees Temp PlaceCount Rupees Else If Temp Then Rupees Temp Rupees.
In the Top Ribbon Go To Developer Tab. Convert numbers to words in Indian rupees with VBA code. You can also manually type the value like SpellNumber 2250.
Paste all text in module and select Spellindian. Then save this code and close the window to go back to the worksheet and select a blank cell type this formula SpellNumberToEnglish A2 A2 is the currency numbers and press Enter key then drag the fill handle down to apply this formula to the cells you need. Set digit groupings to the Indian grouping like this.
Click Insert Module and paste the following code in the Module Window. Now in Excel the Default and Style will show the way you wanted. Convert Currency in Number to Words Indian Rupees - Version 2 Function ConvertCurrencyToEnglish ByVal MyNumber Dim Temp Dim Rupees Paise Dim DecimalPlace Count ReDim Place 9 As String Place 2 Thousand Place 3 lakh Place 4 Crore MyNumber Trim Str MyNumber DecimalPlace InStr MyNumber.
Click on Visual Basic in Code. Press Enter to confirm the formula. Steps to make Excel Formula.
Use the shortcut keys ALT F11 to open the VBA Window Insert a Module from the Insert Drop Down in the Menu Bar In the empty space paste the code and close the VBA Window Now use the SpellNumber function to convert any number in to Indian Currency Words. XDecimal InStr pNumber 3. Use the SpellNumber function in individual cells Type the formula SpellNumber A1 into the cell where you want to display a written number where A1 is the cell containing the number you want to convert.
STEP No6 Keep the cursor in the box where you want to convert numbers into Words in Excel Sheet and type spellnumber the cell number ie in the above if I want to convert F6 cell into words I will type spellnumber F6 and then enter So in this way you can easily convert numbers into words in excel in Pakistani or Indian Rupees. Conditional VLOOKUP in EXCEL. The following VBA code can help you to convert the numbers to words in rupees please do as this.
Indian 50 Rupee Note The Indian 50 Rupee Banknote Inr50 Is A Denomination Of Indian Currency It Was Fir Forex Trading Forex Currency Trading Money Trading
How To Install Rupee Symbol Word Symbols Words Rupees
Excel Formula To Convert Number To Words In Indian Rupees Excel Shortcuts English Words Excel Formula
Pin On Nvs
How To Convert Number To Words In Excel In Rupees
Law Firm Invoice Template Indian Inr Currency Invoice Template Invoice Template Word Freelance Invoice Template
Pin On My Saves
How To Convert Numbers To Words In Indian Rupees In Excel
How To Convert Numbers To Words In Indian Rupees In Excel
Quickly Convert Or Spell Out A Number Into English Words In Excel
How To Convert Number To Words In Excel
How To Show Indian Currency Format In Excel How To Show Indian Number Formats In Excel
Convert Number To Words In Indian Currency Format In Excel 2010
Convert Number To Words In Indian Currency Format In Excel 2010
How To Convert Number Into Word In Excel In Indian Rupees Microsoft Office Excel Formula In Hindi Youtube
How To Convert Numbers Into Words In Exceltfvrdirdvrdmrd Relrdv Rdhrel Rd Rdmrenrdzhrelrdv Rdorezrdv Rdhrdird Rd Renrdya Rdh English Words Workbook Excel Formula
How To Convert Numbers To Words In Indian Rupees In Excel
Pin On My Saves
Indian And International Numbering Lakhs Crores Millions Billions Indian Mathematics Indian System Number System
