Closed Thread
Results 1 to 32 of 32

Spell number in Arabic

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Jeddah, KSA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Spell number in Arabic

    I want to have my numbers spelled in Arabic.

    I checked forum, but none of them has solution.

    I searched over net, find a macro for this, unfortunately it is giving error. (I am not sure why there is error, while I see the comments of other that it is working superb).

    Could someone please help me to find out why the below code give error;



    Please Login or Register  to view this content.


    Looking forward for solution.
    Last edited by 6StringJazzer; 02-07-2014 at 04:01 PM. Reason: code tags to clean up old thread

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Spell number in Arabic

    When I paste this into a VBA window the Arabic characters paste as "?" so I have limited ability to test this. Do you have an Excel file that has this code installed already?

    There are a few errors I can give you specific direction on.
    Please Login or Register  to view this content.
    This is Visual Basic code, not VBA. Although the languages are very similar they are not the same. The keyword Shared is used in Visual Basic but does not exist in VBA. Because you are not using this function as a class function, you can omit Shared.

    You have many declarations with this format:
    Please Login or Register  to view this content.
    In VBA you cannot have a declaration and an initialization on the same line. You must change all of these to this form:
    Please Login or Register  to view this content.
    Math.Floor does not exist in VBA. This is probably a library reference. You can replace it with Int.
    Please Login or Register  to view this content.
    This generates a runtime error:
    Please Login or Register  to view this content.
    Letter2 is a String but you are testing to see if it Is Nothing. You must use an object in that comparison, or it generates a runtime error.

    Once you fix those problems the code will compile and run إن شاء الله but I still don't know if it will do what you want.

  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    Jeddah, KSA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Spell number in Arabic

    I almost changed the codes as told, still there is some error.

    Attached is the file, with code.

    Your help is much appreciated.
    Attached Files Attached Files

  4. #4
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Spell number in Arabic

    Dear Noman,

    As explained by 6StringJazzer, VBA does not allow a declare and initialization on the same line of code.

    You must therefore also change

    Please Login or Register  to view this content.
    into

    Please Login or Register  to view this content.
    for all such lines in your code, so C1 through C6
    If you like my contribution click the star icon!

  5. #5
    Registered User
    Join Date
    06-12-2012
    Location
    Jeddah, KSA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Spell number in Arabic

    Thanks the issue is solved now

    Attached is the file with Code, so any-one can use it.

    Because I found there are lot of threads which are unsolved, for spell number in Arabic.


    Please mark this tread as solved. (I am unable to find the option for that)
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    12-16-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Spell number in Arabic

    it's works! thanks very much!

  7. #7
    Registered User
    Join Date
    02-07-2014
    Location
    Damascus , Syria
    MS-Off Ver
    Excel 2013
    Posts
    1

    Red face Re: Spell number in Arabic

    nomman999 thank you so mush ....it's work

  8. #8
    Registered User
    Join Date
    02-09-2014
    Location
    Abu Dhabi
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Spell number in Arabic

    Issue Arabic.png

    Please see the screenshot to see what I am getting from the above provided excel sheet. Please advise how to fix it. Thanks

  9. #9
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Spell number in Arabic

    rishiwelcome,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  10. #10
    Registered User
    Join Date
    08-12-2014
    Location
    Algeria
    MS-Off Ver
    2007
    Posts
    21

    Re: Spell number in Arabic

    hi! all thanks for the script ..
    well I used this script that u already uploaded : (book1.xlsm)

    but I get two problems :
    1 :
    http://i61.tinypic.com/ve9d83.jpg

    & then this :
    http://i61.tinypic.com/110vipv.jpg

    2 :
    http://i58.tinypic.com/2vn1el0.jpg

    I need help plz & thanks

  11. #11
    Registered User
    Join Date
    04-25-2015
    Location
    iraq
    MS-Off Ver
    2010
    Posts
    1

    Re: Spell number in Arabic

    problems
    6666666666666666.png


    I need help

  12. #12
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Spell number in Arabic

    qais26373,
    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.
    Ben Van Johnson

  13. #13
    Registered User
    Join Date
    03-17-2016
    Location
    India
    MS-Off Ver
    2010
    Posts
    83

    Re: Spell number in Arabic

    Hi,

    I could not able to write Arabic words from above coding in the module

    Capture.PNG

    Kindly solve my above issue.

  14. #14
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Spell number in Arabic

    I think you have to install Arabic through Regional and language from Control Panel ..
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  15. #15
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Spell number in Arabic

    arshad.99.ali, 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.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  16. #16
    Registered User
    Join Date
    06-18-2016
    Location
    Jeddah, Kingdom Of Saudia Arabia
    MS-Off Ver
    2010
    Posts
    3

    Re: Spell number in Arabic

    Assalam O alikum

    Dear I Downloaded this file, it is protected file but when i click on enable editing the arabic transaltion of the number change to
    "ÇËäì ÚÔÑ ÇáÝ æÎãÓãÇÆÉ"

    kindly help me on this issue as i have to print cheques in arabic translation

    Regards
    mimran

  17. #17
    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: Spell number in Arabic

    mimran 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

  18. #18
    Registered User
    Join Date
    07-22-2018
    Location
    Saudi Arabia
    MS-Off Ver
    2016
    Posts
    4

    Re: Spell number in Arabic

    How about if there is a decimal places for example 40,057.23?

  19. #19
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Spell number in Arabic

    Quote Originally Posted by pitbullastog View Post
    How about if there is a decimal places for example 40,057.23?
    Please start a new thread with your question and link back to this one if you think it's relevant.

    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.

  20. #20
    Registered User
    Join Date
    04-03-2019
    Location
    INDONESIA
    MS-Off Ver
    2013
    Posts
    1

    Re: Spell number in Arabic

    how to fixed it? please help me

  21. #21
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Spell number in Arabic

    Quote Originally Posted by MAMHARA2022 View Post
    how to fixed it? please help me
    Administrative Note:

    Welcome to the forum MAMHARA2022

    Your question is not clear, but we are happy to help, and though your request may be 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

  22. #22
    Registered User
    Join Date
    07-12-2020
    Location
    saudi
    MS-Off Ver
    2010
    Posts
    1

    Re: Spell number in Arabic

    Code is working for whole number part, but decimal if any is not working.

    for example 100.50, It spells 100 in arabic correctly, but .50 is not there.

  23. #23
    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: Spell number in Arabic

    Quote Originally Posted by sree4dream View Post
    Code is working for whole number part, but decimal if any is not working.

    for example 100.50, It spells 100 in arabic correctly, but .50 is not there.
    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

  24. #24
    Registered User
    Join Date
    05-11-2019
    Location
    riyadh
    MS-Off Ver
    2016
    Posts
    1

    Re: Spell number in Arabic

    Quote Originally Posted by noman999 View Post
    Thanks the issue is solved now

    Attached is the file with Code, so any-one can use it.

    Because I found there are lot of threads which are unsolved, for spell number in Arabic.


    Please mark this tread as solved. (I am unable to find the option for that)
    Sir, this book helped a lot but in this the decimal values are not converting into word,
    for example if the number is 149.5 the the conversion is مائة وتسعة واربعون
    do we have any solution for complete conversion of a number.

  25. #25
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Spell number in Arabic

    Quote Originally Posted by myyunus4 View Post
    Sir, this book helped a lot but
    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

  26. #26
    Registered User
    Join Date
    09-21-2018
    Location
    Saudi Arabia
    MS-Off Ver
    10
    Posts
    11

    Re: Spell number in Arabic

    I am trying to work on Halala conversion in to Arabic Text.

    In Sha Allah, If get success I will upload full code here so it can be used by whoever need.....

    Ashfaque
    Khobar, Saudi Arabia

  27. #27
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Spell number in Arabic

    Quote Originally Posted by Ashfaque Hussain View Post
    I am trying to work on Halala conversion in to Arabic Text.

    In Sha Allah, If get success I will upload full code here so it can be used by whoever need.....
    Ashfaque,

    Ahlan wa sahlan!

    If you have a question, please start a new thread. If you want to share a tool or technique, please post a new thread in the Tips and Tutorials subforum. Shukrun.

    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

  28. #28
    Registered User
    Join Date
    09-21-2018
    Location
    Saudi Arabia
    MS-Off Ver
    10
    Posts
    11

    Re: Spell number in Arabic

    Thanks,

    That was my formal answer to the user only.

    Rest, when I done, definitely I will start new thread...

    Regards,

  29. #29
    Registered User
    Join Date
    09-21-2018
    Location
    Saudi Arabia
    MS-Off Ver
    10
    Posts
    11

    Re: Spell number in Arabic

    As promised, I have shared Excel version file on this forum to convert values in Arabic words including decimal values up to 2.

    Please click below link to get the file. It is absolutely working with Excel. I have MS Access version also. But this code will also work with MS Access. Mod edit: personal contact details removed.
    Thanks,
    Ashfaque Hussain
    Khobar, Saudi Arabia
    Last edited by AliGW; 01-24-2021 at 06:16 AM.

  30. #30
    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,333

    Re: Spell number in Arabic

    Please post the solution here as well.
    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.

  31. #31
    Registered User
    Join Date
    09-21-2018
    Location
    Saudi Arabia
    MS-Off Ver
    10
    Posts
    11

    Re: Spell number in Arabic

    Here is the file attached.. THIS WILL CONVERT WHOLE VALUE PLUS DECIMAL VALUES IN ARABIC WORKDS.


    ENJOY...

    Ashfaque Hussain
    Khobar
    Saudi Arabia
    Attached Files Attached Files

  32. #32
    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,333

    Re: Spell number in Arabic

    That's an .xlsx file - you need to post the .xlsm version.

    The .xlsm versiuon can be found here: https://www.excelforum.com/access-pr...al-values.html
    Last edited by AliGW; 02-21-2021 at 09:04 AM.

Closed Thread

Thread Information

Users Browsing this Thread

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

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