Benches iCloud and sync

12

can you convert numbers to text?

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

hi everyone,

i was wondering if iwork can convert a number into text. for example, can it translate $500.56 to Five hundred and 56/100 dollars?

12 replies

Sign in or join Beachball Help to reply.

  1. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    That's not working for me, it is removing the tabular structure but I am left with digits and not words.

  2. 0

    Barry

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi Peggy,

    Different question. The OP wanted to "translate $500.56 to Five hundred and 56/100 dollars? "

    Convert Table to Text changes a table of numbers (or text) to a set of tab(and return)-separated text strings in the line of text.

    eg. A 3x3 table containing the numbers 1 to 9 is converted to:

    1tab2tab3return4tab5tab6return7tab8tab9

    and displays in the text as:

    1 2 3

    4 5 6

    7 8 9

    Regards,

    Barry

  3. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    With some effort you could do it. There is not a formula to do the conversion.

  4. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Here is a sample of what can be done. Only goes up to 999.99 but you can add thousands, ten thousands, and on. Hide columns C through G. I left them visible for now. I also notice I did not add the word "dollars" to the end so I'll leave that to you.

    http://files.me.com/pwb3/d8tkzg.numbers.zip

    Edit 1: MobileMe is asking for a password for some reason today, even though this file isn't password protected. I think anything you type for the password will work.

    Edit 2: And I spelled "Forty" incorrectly. There may be other typos as well.

    Message was edited by: Badunit

  5. 0

    Peggy

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Welcome to Apple Discussions

    Numbers can't but Pages can. Copy your Numbers table & paste it as an inline object in Pages & then go to Format > Table > Convert Table to Text.

    User uploaded file

  6. 0

    jungwone85

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    what did you mean by inline object? i copied and pasted the part of table that i want to convert. i tried but it didnt work. it just took out the text or numbers in this case and put them outside the table.

  7. 0

    jungwone85

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thank you badunit! i wrote it so it can convert up to 10,000! Thank you so much.

    Message was edited by: jungwone85

  8. 0

    jungwone85

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    thank you peggy for your time and concern.

  9. 0

    Barry

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Go with badunit's technique.

    It's similar to what I did with AppleWorks some years ago to produce worksheets ('Write one thousand two hundred seventeen and five tenths as a numeral.') for my upper elementary students, and modified later to print cheques.

    I used a different method deconstruct the number, but within the limits stated, bu's technique does the job nicely.

    Regards,

    Barry

    Edit: I see you've decided to do that while I was looking for my old file. 🙂

    B

  10. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    You're welcome.

  11. 0

    Peggy

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thanks, it's been a tough day & my brain was functioning on less cells than usual. 😉 Things are looking up now & after a good night's sleep I will probably be more functional tomorrow.

    User uploaded file

  12. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    If my memory is not too bad from my iDisk:

    <http://idisk.me.com/koenigyvan-Public?view=web&gt;

    you may get for free:

    For_iWork:iWork '08:for
    Numbers:Nbr_in_Letters_forNumbers.zip

    which was written to do the trick.

    If it's really fitting the OP's needs, I may enhance it to take benefit of features added in Numbers '09.

    Yvan KOENIG (VALLAURIS, France) mardi 27 octobre 2009 20:53:42