Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Value to Text

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

    Default

    I am looking for a function which can convert/translate the value into text. For example, if I have a value "1000" in cell A1 then I would it to display "one thousand dollar" in cell B1. Can anyone suggest me how to do it automatically as I have to do it manually in thousand of cells.

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you. On My computer "SpellNumber" function does not work. Do you know why? But the other example works.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tum,

    it's a user-defined function, not an in-built one...

    if you scroll down on that sheet, it gives you the code you need to enter in your VBA module thingy before it will work by just typing =SPELLNUMBER

    if you follow the link in Aladin's suggestion, it has an addin that has already done all this for you (and a whole lot more), which I personally think is more convenient

    anyhow,


    :: Pharma Z - Family drugstore ::

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
  •