Share via

VBA code to convert amount in figures into words in Indian number style

Anonymous
2025-02-22T12:39:12+00:00

I wan a formula or VBA code to convert amount in figures into words in Indian number style.

Suppose my amount is Rs. 10'15'24'532/-. It should be converted as Rupees Ten Crore Fifteen Lacs Twenty four thousand five hundred thirty two.

Please help.

Thanks & regaqrds,

HD Sharma

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2025-02-22T13:49:58+00:00

    2 people found this answer helpful.
    0 comments
  2. HansV 462.6K Reputation points MVP Volunteer Moderator
    2025-02-23T08:41:04+00:00

    I have modified the code from the page I linked to so that Paise is not displayed for whole numbers. See Number-to-Words-indian-rupee.xlsm

    Make sure that you allow macros when you open the workbook.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2025-02-23T10:49:43+00:00

    Sir I am not able to get the result. I am inserting your VBA code in my a VBA (not VBE, as mentioned by you in your reply) module.

    Would be grateful if you could give me a detailed step wise path; like after opening the file I am working in, I will press Alt+F11 to get a VBA window. In the VBA window, from the Insert Tab I am inserting Module.

    What to do hereafter. whether this file needs to be saved, if yes, where it should be saved. Please guide me with detailed steps please.

    I would be grateful for your support, Sir.

    HD Sharma

    0 comments
  4. Anonymous
    2025-02-23T08:30:21+00:00

    Also please see if there is no paisa value, then it should not say "zero paise".

    0 comments
  5. Anonymous
    2025-02-23T08:28:51+00:00

    Sir, many thanks for providing the VBA code, but I am not able to get the result when I copy your codes and paste it by following the undermentioned steps in my Excel file :

    • Insert module
    • paste the code in the module
    • then save it

    After this, inserting the formula NUM_TO_IND_RUPEE_WORD in the desired cell, I am getting any resuslt.

    Could you please help me how to get it.

    0 comments