Describe a number as text????
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Describe a number as text????

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    142
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is it possible to have a cell look at another cell's number, then produce the text version of that number?

    i.e.
    A1=$128,554
    (therefore)
    A2="One hundred twenty eight thousand, five hundred fifty four"

    I know I could probably make it work with a lookup, but if there's anyone who knows a more elegant and simple way...please chime in!!!

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Try using the search and search for
    Numbers to text....this usbject has been covered before on the New board as well as
    the Old one.

    Good hunting

    Ivan

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    142
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have looked around...not found anything yet on this topic. I'll keep looking.

    In the meantime, if anyone can provide input on this or steer me in another researchable direction, I'd appreciate it!

    Thanks.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Default

      
    I have a spreadsheet that does this for numbers without decimals. You can get the idea on how I did it. If you send me a email address of if you know how to attach a file here I'll send same to you.

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
  •  

 

 
DMCA.com