Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005

    Unanswered: Convert number into text

    Dear All

    I want to convert number into text. Suppose A cell has (250) figures of amount in Rupees. Next cell should display as (Two Hundres fifty rupees only)

    I used function BAHTTEXT but it convert in Thai Language.



  2. #2
    Join Date
    Sep 2008
    London, UK
    Hello Wasim,

    Here are 3 different options for you:

    1. You can download and install ASAP Utilities
    ASAP Utilities - Numbers » Spell/write out numbers or amounts (EN, DE, NL)... - List of tools - Excel software

    2. You can write a VBA UDF, examples:
    How to convert a numeric value into English words in Excel
    VBA Express : Multiple Apps - Change number into complete words, including currency names

    3. You can use a formula-driven approach; there is an example you can download and adapt from MS MVP Debra Dalgleish's site:

    Hope that helps...

Posting Permissions

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