How to Convert Rupee into Dollar, Paise, and Words in Excel (Step-by-Step Guide)

Currency conversion and formatting are among the most common requirements in finance, banking, accounting, and Excel usage. Many people search for:

How to convert Rupee into Dollar?
How to convert Paise into Rupees?
How to convert Rupee into Words in Excel?
How to convert Rupee into Dollar in Excel?

This article covers all these queries with formulas, examples, and tips so that you never have to search elsewhere.

1. How to Convert Rupee into Dollar?

Formula for Conversion

To convert Indian Rupees (INR) into US Dollars (USD): Dollar (USD)=Rupee (INR)Current Exchange Rate\text{Dollar (USD)} = \frac{\text{Rupee (INR)}}{\text{Current Exchange Rate}}

👉 Example: If 1 USD = ₹83, then:

₹830 ÷ 83 = $10
₹8,300 ÷ 83 = $100

Where to Check Latest Exchange Rate?

Google Search: Just type “1 INR to USD”
Forex Websites: XE, Investing.com, RBI, etc.
Bank Apps: HDFC, SBI, ICICI, Paytm

2. How to Convert Paise into Rupees?

Since 1 Rupee = 100 Paise: Rupee=Paise100\text{Rupee} = \frac{\text{Paise}}{100}

👉 Example:

250 Paise = 250 ÷ 100 = ₹2.50
50 Paise = ₹0.50

3. How to Convert Rupee into Words in Excel?

Excel does not have a built-in function to convert numbers into words, but you can use VBA or Add-ins.

VBA Method:

Open Excel → Press Alt + F11
Insert → Module → Paste the following VBA code:

Function SpellNumber(ByVal MyNumber)
Dim Units As String
Dim SubUnits As String
Dim Temp As String
Dim DecimalPlace As Integer
Dim Count As Integer
Dim Place(9) As String
Place(2) = ” Thousand “
Place(3) = ” Lakh “
Place(4) = ” Crore “

‘ Convert MyNumber to words
MyNumber = Trim(Str(MyNumber))
DecimalPlace = InStr(MyNumber, “.”)
If DecimalPlace > 0 Then
SubUnits = ” Paise ” & Mid(MyNumber, DecimalPlace + 1) & ” Only”
MyNumber = Left(MyNumber, DecimalPlace – 1)
End If

Count = 1
Do While MyNumber <> “”
Temp = ConvertHundreds(Right(MyNumber, 3))
If Temp <> “” Then Units = Temp & Place(Count) & Units
If Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) – 3)
Else
MyNumber = “”
End If
Count = Count + 1
Loop

SpellNumber = Units & SubUnits
End Function