Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Converting #'s to words???? can I do it

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Im trying to find out if there is a formula or someway that if I put a Dollar amount in one cell that it would convert it to words onto another cell
    Can anyone help
    thanx, Rose

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what words did you want?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if the dollar is in g19

    =IF(G19="$","Dollar","No Dollar")
    put the formula in g20 or any othe cell

    [ This Message was edited by: brettvba on 2002-04-30 13:41 ]

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,006
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-30 13:28, Rosesemails wrote:
    Im trying to find out if there is a formula or someway that if I put a Dollar amount in one cell that it would convert it to words onto another cell
    Can anyone help
    thanx, Rose
    Use NUMTEXT from morefunc add-in by Longre, downloadable at:

    http://perso.wanadoo.fr/longre/excel/downloads/

    It's in English.

  5. #5
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just to be complete, the following post from Harlan Grove does the reverse -- from words to numbers.

    http://groups.google.com/groups?hl=e...rldnet.att.net

    ...and true to Harlan's style, he does something really clever *AND* takes a small jab at an Excel MVP in his reply.

    Bye,
    Jay

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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