12 replies
Sign in or join Beachball Help to reply.
- 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.
- 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 9Regards,
Barry - 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.
- 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
- 0
Peggy ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
- 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.
- 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
- 0
jungwone85 ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
thank you peggy for your time and concern.
- 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,
BarryEdit: I see you've decided to do that while I was looking for my old file. 🙂
B - 0
- 0
Peggy ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
- 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>
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
