Results 1 to 10 of 11

Thread: Yet Another Number-To-Words Function (Sorry, US Style Only)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    Junior Member
    Join Date
    Aug 2020
    Posts
    2
    Rep Power
    0
    Dear Sir,

    I'm very thankful to you that, you made very useful VBA formula. I found if this formula can work like this it will be very easy to input formula in multiple formatting

    Example:

    =NumberAsText(A1) ==> One Hundred Twenty Three Point Four Five
    =NumberAsTextAnd(A1) ==> One Hundred and Twenty Three Point Four Five
    =NumberAsTextCheck(A1) ==> One Hundred Twenty Three and 45/100
    =NumberAsTextDollar(A1) ==> One Hundred Twenty Three Dollars and Forty Five Cents
    =NumberAsTextCheckDollar(A1) ==> One Hundred Twenty Three Dollars and 45/100
    =NumberAsTextCheckRiyals(A1) ==> One Hundred Twenty Three Riyals and 45/100

    5555.jpg

    Please see attached snap if this formula work like this it will be much easier to choice any format.

    Thank you so much your for your kind attention

    Regards,
    Last edited by ipi99; 08-06-2020 at 02:46 PM. Reason: Photo attached

Similar Threads

  1. Number into words (Rupees)
    By Admin in forum Download Center
    Replies: 2
    Last Post: 06-14-2014, 12:05 AM
  2. Number to Words (Rupees)
    By vishwajeet_chakravorty in forum Excel Help
    Replies: 8
    Last Post: 02-24-2014, 09:26 PM
  3. Excel Number Format: Indian Style Comma Separation
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 6
    Last Post: 09-18-2013, 11:38 AM
  4. Follow-up to "Excel Number Format: Indian Style Comma Separation"
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 2
    Last Post: 04-14-2012, 10:46 PM
  5. Number to Words (Rupees)
    By sa.1985 in forum Excel Help
    Replies: 2
    Last Post: 12-16-2011, 08:57 PM

Tags for this Thread

Posting Permissions

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