+ Reply to Thread
Results 1 to 7 of 7

Convert numbers into words for printing checks

  1. #1
    Registered User
    Join Date
    12-09-2020
    Location
    Kuwait
    MS-Off Ver
    MS 365
    Posts
    3

    Lightbulb Convert numbers into words for printing checks

    Dear All,

    I am new here. I need help in conversion of numbers into words for printing checks.

    I need a macro (button) that converts, for example, KWD 5,550.850 into (Kuwaiti Dinars Five Thousand Five Hundred Fifty and 850 Fils Only)

    Thanks alot.

    Waleed

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2506 Win 11
    Posts
    24,913

    Re: Convert numbers into words for printing checks

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Read this to understand why we ask you to do this.

    I have added the crosspost reference for you today. Please comply with this and all our rules in the future


    https://www.ozgrid.com/forum/index.p...inting-checks/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,469

    Re: Convert numbers into words for printing checks

    This is one method :

    Please Login or Register  to view this content.
    NOTE: The above is only a small segment of the entire code. Review attached file.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-09-2020
    Location
    Kuwait
    MS-Off Ver
    MS 365
    Posts
    3

    Re: Convert numbers into words for printing checks

    Thanks, its working

  5. #5
    Registered User
    Join Date
    12-09-2020
    Location
    Kuwait
    MS-Off Ver
    MS 365
    Posts
    3

    Re: Convert numbers into words for printing checks

    Noted, will comply with rules.

    Thanks

  6. #6
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,713

    Re: Convert numbers into words for printing checks

    Hi Waleed,

    I have modified the code slightly to cater for "Kuwaiti Dinars" and "Fils". Also, I have added another function to do the same but in Arabic as well in case you need it
    Attached Files Attached Files
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,469

    Re: Convert numbers into words for printing checks

    You are welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert numbers to words
    By kipminorball in forum Excel General
    Replies: 5
    Last Post: 02-13-2016, 10:35 PM
  2. Replies: 8
    Last Post: 06-28-2014, 03:26 PM
  3. Convert words to numbers
    By SUNSHYN in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-23-2012, 07:00 AM
  4. How do I convert numbers to words writing checks with Excel?
    By Pablo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2005, 04:15 PM
  5. convert numbers to words
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  6. convert numbers to words
    By prags in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. [SOLVED] How do I spell numbers as words for writing checks in Excel?
    By Heather in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2005, 05:06 PM

Tags for this Thread

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