+ Reply to Thread
Results 1 to 5 of 5

Convert amount in cell to words

  1. #1
    Registered User
    Join Date
    09-23-2005
    Posts
    11

    Convert amount in cell to words

    hi
    pls help me with the formula to convert amount in cell to words like it shows sometimes on commercial invoices
    thanks
    raj

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    http://www.meadinkent.co.uk/xlnumberstext.htm

    This Web Site has the function you request

    once you have copied and pasted the code into a module, the formula will be =WordNum(A1) if your value is in A1

  3. #3
    Paul B
    Guest

    Re: Convert amount in cell to words

    Raj, have a look here, http://www.xldynamic.com/source/xld.xlFAQ0004.html

    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "Raj Shah" <[email protected]> wrote in
    message news:[email protected]...
    >
    > hi
    > pls help me with the formula to convert amount in cell to words like it
    > shows sometimes on commercial invoices
    > thanks
    > raj
    >
    >
    > --
    > Raj Shah
    > ------------------------------------------------------------------------
    > Raj Shah's Profile:

    http://www.excelforum.com/member.php...o&userid=27505
    > View this thread: http://www.excelforum.com/showthread...hreadid=534075
    >




  4. #4
    Registered User
    Join Date
    09-23-2005
    Posts
    11
    many thanks
    raj

    Quote Originally Posted by davesexcel
    http://www.meadinkent.co.uk/xlnumberstext.htm

    This Web Site has the function you request

    once you have copied and pasted the code into a module, the formula will be =WordNum(A1) if your value is in A1

  5. #5
    Registered User
    Join Date
    09-23-2005
    Posts
    11
    many thanks
    raj

    Quote Originally Posted by Paul B
    Raj, have a look here, http://www.xldynamic.com/source/xld.xlFAQ0004.html

    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "Raj Shah" <[email protected]> wrote in
    message news:[email protected]...
    >
    > hi
    > pls help me with the formula to convert amount in cell to words like it
    > shows sometimes on commercial invoices
    > thanks
    > raj
    >
    >
    > --
    > Raj Shah
    > ------------------------------------------------------------------------
    > Raj Shah's Profile:

    http://www.excelforum.com/member.php...o&userid=27505
    > View this thread: http://www.excelforum.com/showthread...hreadid=534075
    >

+ Reply to 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