Closed Thread
Results 1 to 38 of 38

Function request to change numbers to word in Hindi

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Function request to change numbers to word in Hindi

    Hi friends,
    I'm in a urgent need of a function to change numbers to word function for Hindi language.I found a function in English/Arobic language on forum search but not for Hindi language. I want to convert the Indian currency numbers to words.

    For your reference I'm attaching here a workbook which changes a amount to word in arobic.

    Any help will be highly appreciated.

    Thanking you in anticipation.
    Attached Files Attached Files
    Last edited by mso3; 04-26-2015 at 12:48 AM. Reason: Attach a sample workbook for reference
    Sincerely,

    mso3

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    Please find the attached and see if this works as per your requirement.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    09-28-2012
    Location
    gujarat
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Function request to change numbers to word in Hindi

    Dear sir but how we do this individually kindly reply

  4. #4
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Function request to change numbers to word in Hindi

    Hi Sktneer,
    Excellent! What a challenging creation. I appreciate you for taking a trouble to create such a challenging UDF. I don't want to trouble you more because I can understand how much time and trouble you have taken to create this UDF. Actually, I want to convert a amount Indian currency (rupees and paise) in words.

    I request all of you excel experts to look into this problem and modify the UDF created by Sktneer to meet the requirement. It will be more helpful for our friends because there is not a such UDF or function is available like English to convert a amount in words for Hindi.

    Waiting to receive a solution eagerly. Please take it urgent because I'm unable to complete my project.

    Thanking you in anticipation.

  5. #5
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Function request to change numbers to word in Hindi

    8734404 सत्य़ांशी लाख चौतीस हजार चार सौ चार
    Sktneer code is doing an excellent job for you.

    if I am wrong, then what is the meaning of this line of yours.
    "I want to convert a amount Indian currency (rupees and paise) in words."
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  6. #6
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Function request to change numbers to word in Hindi

    Hi Vikas,
    Yes, no matter Sktneer has done a excellent challenging job. I have already appreciated him for the same. However I need a little amendment in it for rupees and paise as 'सत्य़ांशी लाख चौतीस हजार चार सौ चार रूपये व शून्य पैसे'

    I don't want a space between number in word and सो.

    ८७४०४ should be as 'सत्य़ांशी लाख चौतीस हजार चारसौ चार रूपये व शून्य पैसे'

    Hope this example will help you to understand my requirement.

    Thank you.

  7. #7
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    @Vikas

    Thanks for liking the work. I don't know whether it is the best approach to achieve this but honestly I had no other approach to adopt.

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    Please find the attached workbook.
    I have tried to tweak the code as per your requirement. See if this works this time as expected.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    04-20-2015
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    17

    Thumbs up Re: Function request to change numbers to word in Hindi

    Hi Sktneer,

    This is marvelous work. I am new to macro and after looking at your macro, I am amazed. Hi5 for you. I am just dropping this reply to show how impressive of work you did there.

  10. #10
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    Hi Amity21,

    Thanks for encouraging words. I really appreciate that.
    Glad you liked the solution.

  11. #11
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Function request to change numbers to word in Hindi

    Hi Sktneer,

    Waw! Excellent! Excellent! Excellent!

    Really, I don't have words to appreciate you for the ever first excellent challenging UDF to convert Indian currency in words. I googled for it for a long time but not found any solution so I posted my request on the forum and receive a concrete solution from you. Keep it up. Every user will remember you for it.

    Finally, once again I appreciate you for your challenging creation.

    Have a nice time.

  12. #12
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    Please find the attached workbook with the change requested.
    Attached Files Attached Files

  13. #13
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    And thanks for the compliment and the feedback as well.

  14. #14
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Function request to change numbers to word in Hindi

    Hi Sktneer,
    Perfect!

    I'm feeling very sorry to trouble you again but to make the UDF full proof as per Marathi language I need a little amendment in it as shown in the column 'C' attached workbook. I have change the name of function Hindi to Marathi to avoide any confusion.
    There is a little difference between Hindi and Marathi language so the amendment is require.

    After this final amendment the UDF will be complete. Credit goes to you for your patience and hard work on it to achieve the target.

    Sorry for trouble.

    Thanking you in anticipation.

    Have a nice day!
    Attached Files Attached Files
    Last edited by mso3; 04-29-2015 at 06:23 AM.

  15. #15
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    Please see the attached.
    Attached Files Attached Files

  16. #16
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Function request to change numbers to word in Hindi

    Hi Sktneer,

    Excellent! Now it's 100% perfect.

    Thank you for taking a trouble to create such a excellent probably ever first UDF to convert Indian currency in local languages. I googled for it but not found any solution so that I think it may be the ever first UDF. I by heart appreciate you for the same and appeal all of excel forum friends to appreciate you for your excellent creation.

    Thank you and have a nice time.

  17. #17
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    You're welcome and thanks for the feedback as well.

  18. #18
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Function request to change numbers to word in Hindi

    Hi Sktneer,

    Good morning!

    First of all I take an opportunity to congratulate you for creating an excellent UDF for Marathi.

    I’m using it in my daily work but now I have a problem of some numbers mentioned below which are not spell correctly in words.
    Please Login or Register  to view this content.
    I’m feeling very sorry to trouble you repeatedly but I’m optimistic to receive a concrete solution from you and I don’t have any alternative. You have an idea of it so I’m asking you.

    Thanking you in anticipation.

    Have a nice day!
    Attached Files Attached Files

  19. #19
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Function request to change numbers to word in Hindi

    Bump!

    Hi Sktneer and forum experts,

    Please do look into my my problem and suggest me a solution to get perfect output positively.

    Waiting eagerly to receive a solution today positively.

    Sorry for trouble and have a nice day.

    Any help will be highly appreciated.

  20. #20
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    Don't take it otherwise but please don't PM me regarding a thread. This is against the forum rules.

    Please find the attached workbook to see if the tweaked code is working as per your expectations.
    Attached Files Attached Files

  21. #21
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Function request to change numbers to word in Hindi

    Hi Sktneer,

    I felt very sorry to read a instruction not to pm you on the forum. Doesn't matter you may pm me and instruct the same would be more better for me.

    I was in a urgent need of a solution to use the UDF in my program so I pm to you. Sorry for the same and I assure you that I will not pm to you in future to disturb you. I respect your privacy.

    Thank you for the solution which is working fine.

    I by heart appreciate you for the same and expect such a kind cooperation/guidance in future positively.
    please don't mind.

    Thank you and have a nice day.

  22. #22
    Registered User
    Join Date
    07-22-2015
    Location
    qatar
    MS-Off Ver
    2007
    Posts
    7

    Re: Function request to change numbers to word in Hindi

    Dear sktneer,

    Please provide update for "करोड' also.

    Anyways, you have provided a very good tools to convert number into English, Marathi, Hindi.

    Thnx

    VVK

  23. #23
    Registered User
    Join Date
    07-22-2015
    Location
    qatar
    MS-Off Ver
    2007
    Posts
    7

    Re: Function request to change numbers to word in Hindi

    Dear sktneer

    Please also fix this - 9900000.00 नव्य़ानव लाख नव्वद हजार रुपये शून्य पैसे

    Regards

    VVK

  24. #24
    Registered User
    Join Date
    07-22-2015
    Location
    qatar
    MS-Off Ver
    2007
    Posts
    7

    Re: Function request to change numbers to word in Hindi

    Hi mso3

    Have you seen my message reg. the above post.

    Regards


    VVK

  25. #25
    Registered User
    Join Date
    02-25-2016
    Location
    Agar
    MS-Off Ver
    2007
    Posts
    1

    Re: Function request to change numbers to word in Hindi

    Brothers,

    I don't need paise like this "दस रुपये शून्य पैसे"

    Can you pls remove paise and round figure it like "दस रूपए मात्र)

  26. #26
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Function request to change numbers to word in Hindi

    Dear Both,

    The udf is created by a excel master 'Sktneer' and he is the only person to amend the challenging udf. I'm not able to amend it. Therefore, I request Sktneer to look in to this problems and make the udf more perfect.

    Thank you.

  27. #27
    Registered User
    Join Date
    04-26-2017
    Location
    India
    MS-Off Ver
    2003
    Posts
    4

    Re: Function request to change numbers to word in Hindi

    Sir,
    your code is to good but its not support Crore & if Paise value is .00 then remove Paise(word).

  28. #28
    Registered User
    Join Date
    06-18-2018
    Location
    Jodhour
    MS-Off Ver
    2010
    Posts
    1

    Re: Function request to change numbers to word in Hindi

    Hi friends,

    currently, I am working on an excel sheet which requires Hindi conversion from a numeric value.

    can someone help me out?

  29. #29
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Function request to change numbers to word in Hindi

    Govind_ welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  30. #30
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    I will try to tweak it as per the requests as soon as I get some time.
    If you open a new question, please post it's link here also.

  31. #31
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Function request to change numbers to word in Hindi

    As I promised, here is a function which can be used to convert Numbers into numbers in Hindi words.
    You will find some examples in columns B and C on Sheet1 to know how this function can be used.
    If you are interested in converting numbers to any other language, all you need is, rename the Sheet2 (Hindi Numbers) according to your language and then convert individual numbers into your own language using Google Input Tool on Sheet2 (Hindi Numbers). And then the same function will work for your own language.

    The function NumberToWord accepts two arguments NumberToWord(Num As Double, Optional ZeroPaise As Boolean = True), as you can see that the second argument ZeroPaise is optional i.e. if you omit this argument, the function will return zero paisa in your language and if you use False as second argument, the function will exclude zero paisa from the resultant string.
    In Column B on Sheet1, the function uses only one argument and in Column C, the function uses two arguments.
    e.g.
    B2 =NumberToWord(A2)
    C2 =NumberToWord(A2,FALSE)

    Hope you will find this helpful.
    Attached Files Attached Files

  32. #32
    Registered User
    Join Date
    02-19-2019
    Location
    india
    MS-Off Ver
    2007
    Posts
    3

    Re: Function request to change numbers to word in Hindi

    wow! Superb. Great Effort

  33. #33
    Registered User
    Join Date
    02-19-2019
    Location
    india
    MS-Off Ver
    2007
    Posts
    3

    Re: Function request to change numbers to word in Hindi

    Hi Sktneer Sir

    Sir, Your work is really really amazing. I also gave you many many thanks but spell numbers in hindi.xlsm‎ not work for crore and ten crore digits please solve the problem please.

  34. #34
    Registered User
    Join Date
    02-19-2019
    Location
    india
    MS-Off Ver
    2007
    Posts
    3

    Re: Function request to change numbers to word in Hindi

    thanks to your NumbersToHindi.xlsm‎ all solution. amaze. thank you thank you very much sir.

  35. #35
    Registered User
    Join Date
    02-10-2016
    Location
    INDIA
    MS-Off Ver
    2010
    Posts
    1

    Re: Function request to change numbers to word in Hindi

    Sir i appreciate your work,i tried but it went wrong,so plz hlp me in code
    I want number converted into crorer in hindi words
    it only converts upto 99 lakhs

  36. #36
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,342

    Re: Function request to change numbers to word in Hindi

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  37. #37
    Registered User
    Join Date
    05-31-2020
    Location
    india
    MS-Off Ver
    8.1
    Posts
    1

    Re: Function request to change numbers to word in Hindi

    how can i convert it for use in marathi

  38. #38
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,342

    Re: Function request to change numbers to word in Hindi

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] how do write numbers in hindi?
    By Marwa Amin in forum Excel General
    Replies: 2
    Last Post: 01-07-2015, 04:05 AM
  2. [SOLVED] Help require to get output in Hindi numbers by formula used
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-24-2014, 11:13 PM
  3. Replies: 2
    Last Post: 10-13-2006, 08:41 AM
  4. how to change digital numbers to word?
    By AMIR SAYYED in forum Excel General
    Replies: 1
    Last Post: 07-26-2006, 02:55 AM
  5. [SOLVED] how do i get numbers in arabic not hindi?
    By marie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-19-2005, 01:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1