VBA & Macro Problems

How to Convert Numbers to Words Using Indian Rupee in Excel

Maira Mehtab Sep 22, 2026 868 views

Question details

The user wants to convert numerical amounts into text words using the Indian numbering system (Lakhs and Crores) in Excel.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Preparing financial reports, invoices, or payroll sheets where numerical amounts must be spelled out in Indian Rupees.
Observed behavior: Numbers like 10,15,24,532 need to be programmatically converted and displayed as text, such as 'Rupees Ten Crore Fifteen Lakh Twenty-Four Thousand Five Hundred Thirty-Two'.

Before you start

Ensure you have a reliable VBA code snippet for the Indian Rupee conversion ready, and be prepared to save your workbook as a macro-enabled file.

Solution 1Recommended

Use a VBA Macro Custom Function

Since Excel does not have a built-in formula for this, you must create a custom User-Defined Function (UDF) using VBA to convert numbers into Indian Rupee text format.

By utilizing the Visual Basic Editor, you can insert a script that calculates and translates numerical values into Indian Rupee formats like Lakhs and Crores automatically.

Open Visual Basic Editor

Press Alt + F11 on your keyboard to open the Visual Basic for Applications (VBA) Editor in Excel.

Insert a New Module

In the top menu, click on Insert > Module. A blank window will appear where you can paste your specific Indian rupee number-to-words VBA code.

Apply the Custom Function

Close the VBA Editor. In your spreadsheet, assuming the numeric amount is in cell A2, click cell B2 and enter the formula =NUM_TO_IND_RUPEE_WORD(A2,1) (ensure the function name exactly matches the one defined in your VBA code).

Save as Macro-Enabled Workbook

Go to File > Save As, and choose 'Excel Macro-Enabled Workbook (*.xlsm)' from the file format dropdown. This ensures your custom VBA function is saved and works the next time you open the file.

Macro Security Warning: For security reasons, only enable macros when you open workbooks from trusted sources or when you have pasted the VBA code yourself.

VBA Support in WPS

Run Custom VBA Macros Seamlessly in WPS Spreadsheet

WPS Spreadsheet provides powerful support for VBA macros, allowing you to use custom functions for tasks like Indian Rupee number-to-words conversion just like you would in Excel.

1. Open WPS Spreadsheet: Launch WPS Office and open your financial workbook or create a new one.
2. Access the VBA Editor: Navigate to the Tools tab and click on 'VBA Editor', or simply press Alt + F11.
3. Insert and Run Your Code: Insert a new module, paste your number-to-words conversion script, and use the custom formula directly in your spreadsheet cells.

Fully compatible with Microsoft Excel .xlsm and .xlsx formats.Built-in VBA Editor for running customized macros and user-defined functions.Lightweight, fast, and optimized for older or low-spec devices.Rich library of free templates for invoices and financial reporting.

microsoft office alternative - wps office

Frequently Asked Questions

Why am I getting a '#NAME?' error when using the conversion formula?

The '#NAME?' error usually occurs if macros are disabled, the VBA module wasn't saved properly, or the function name typed in your cell does not perfectly match the function name declared in the VBA code.

Can I save the file as a standard .xlsx workbook?

No, standard Excel workbooks (.xlsx) cannot store VBA macro code. You must save your file as an Excel Macro-Enabled Workbook (.xlsm) for the custom conversion function to remain active.

Does Excel have a built-in function to convert numbers to words?

Excel does not have a native built-in function for converting numbers to text words. You must use a custom VBA macro or a third-party add-in to achieve this functionality.

Excel & Data Problems