Currently Being ModeratedOct 22, 2012 1:33 PM (in response to DirekRod)
I mostly solved this but the Numbers doc is on my computer at home. I will post back pater this evening. I know the solution was not a single cell solution so I will also review how possible that is.
Currently Being ModeratedOct 22, 2012 6:00 PM (in response to DirekRod)
Here is a Numbers document with my previous work. It will take some work to adapter to be useful for you purposes but does show *A* way to do this. I think a substantial rewrite is necessary to make it generally useable...
Currently Being ModeratedOct 22, 2012 9:24 PM (in response to Wayne Contello)
Hi Wayne, THANK YOU SOOO MUCH for taking much effort to attend to my query! ;-))
Should I further request for your helping hands, got to review your doc, but it seems don't have provision for the centavos (decimal places) of the amount. Can you also please help me on that?
Thanks and best regards,
Currently Being ModeratedOct 24, 2012 3:22 PM (in response to Wayne Contello)
Hi Wayne, you are such a wizard angel in my work-life. THANK YOU and may God bless you always!
Currently Being ModeratedDec 11, 2012 12:46 AM (in response to Wayne Contello)
I saw your file and it works beautifully. However I would like to change the cents into words as well. How to change the formulae?
For example, 5000.56 = Five thousand and fifty-six cents only
200.90 = Two Hundred and Ninety cents only
Hope you can help out with my work.
Thanks a million!
Currently Being ModeratedOct 27, 2013 5:51 AM (in response to DirekRod)
I guess solution was great for older versions of numbers.
I tried to used this file in newly updated version 3 - and there are only errors.
I did not understood what needs to be fixed.
Has anyone did it?
Currently Being ModeratedOct 27, 2013 6:29 AM (in response to Mikhail Goncharov)
Try this website I found:
I will look at how to use an Applescript to perform the conversion but I cannot get to it right now.
Currently Being ModeratedOct 28, 2013 9:42 PM (in response to DirekRod)
I think I've got this one licked in 3.0!
Download this file: http://goo.gl/Q10xx8
It should work well for checks and the like.
Tweak to your hearts delight!