How to convert numbers into words in Indian Currency Format

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: How to convert numbers into words in Indian Currency Format

  1. #1
    New Member
    Join Date
    Jul 2013
    Location
    Nagpur, INDIA
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to convert numbers into words in Indian Currency Format

     
    How to convert numbers into words in Microsoft excel in Indian Currency format.

    I wants to convert numbers into the following format.
    1) to convert 12,23,12,123.56 into "Rupees Twelve Crores Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three and Fifty Six Paise Only".
    3) to convert 1,01,01,123.56 into "Rupees One Crore One Lakh One Thousand One Hundred Twenty Three and Fifty Six Paise Only".
    3) to convert 23,12,123.00 into "Rupees Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three Only".

    Please help. Thanks in advance.

    - Abhinav Binkar

  2. #2
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,242
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    3 Thread(s)

    Default Re: How to convert numbers into words in Indian Currency Format

    abinkar,

    There is a lot of information out there if you do a search on the web for:

    excel vba convert number to words

    excel vba convert number to words Indian Currency
    Last edited by hiker95; Jun 17th, 2016 at 07:43 AM.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  3. #3
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,242
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    3 Thread(s)

    Default Re: How to convert numbers into words in Indian Currency Format

    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  4. #4
    New Member
    Join Date
    Jul 2013
    Location
    Nagpur, INDIA
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to convert numbers into words in Indian Currency Format

    Thanks but i was unable to find the one with below particular conditions.

    1) to convert 12,23,12,123.56 into "Rupees Twelve Crores Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three and Fifty Six Paise Only".
    3) to convert 1,01,01,123.56 into "Rupees One Crore One Lakh One Thousand One Hundred Twenty Three and Fifty Six Paise Only".
    3) to convert 23,12,123.00 into "Rupees Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three Only".

    Please help sir.

  5. #5
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,242
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    3 Thread(s)

    Default Re: How to convert numbers into words in Indian Currency Format

    Thanks
    abinkar,

    You are welcome.

    but i was unable to find the one with below particular conditions.
    Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  6. #6
    New Member
    Join Date
    Jul 2013
    Location
    Nagpur, INDIA
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to convert numbers into words in Indian Currency Format

      
    Bump
    Last edited by abinkar; Jun 18th, 2016 at 12:41 AM.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com