Convert numbers to text
Using Filemaker 9.0 and need to convert dollars and cents to words so I can print checks. I've seen some of formulas on the Internet and they don't seem to work. Any suggestions or links?
I found the calculation that I pasted into a calc field.
Thanks for the response. I tried that calc before and couldn't get it to work. When I used it, it returned a blank space....no words.
It's an old article that hasn't been fully updated unless they have done so since the last time that I looked at it, but it should work for you. I recommend re-visiting that article and trying to build it one small part at a time untill you get it working.
Did you change the Input FieldName of the Calculation to match the name of the Number Field you have. I pasted the calculation to Word. Then did a search and replace for 'NumberField' to 'Amount'. Then I pasted that to a calc field. It worked first time in my table in FMP12
Yes, I changed the NumberField but in my case it's not a number field, it's a summary. Can a summary calc be used in this equation? I'm working on a project that I haven't touched in years so becoming familiar with the program again is very time consuming.
Can you explain the first part of the calc "CalculationField (text result) =" a little so I can figure out how to change it.
Simply omit that part from the calculation dialog.
Thanks again for your time. So the calc starts here?
Choose(Int(Mod(Grand Total amount after payment;10^12) / 10^11); ""; "One Hundred "; "Two Hundred "; "Three Hundred "; "Four Hundred "; "Five Hundred "; "Six Hundred "; "Seven Hundred "; "Eight Hundred "; "Nine Hundred ") &
Yes, exactly. That should work for you. now. Using a summary field will work, as long as it is correctly being displayed from a summary part on the layout.
I haven't had a lot of time to work on it this week so hit it this morning for a few minutes and I got it to work. Thanks for your help.
I was able to copy and paste the formula noted in the "Knowledge Base, Answer ID 2860 last updated 1/18/12) into a new field as noted but when it returns the written words, I get a semi-colon after the first two words, (ie eighty nine thousand; one hundred two dollars and fifty cents). Can you give me any ideas on why this might be happening and how to correct it? I currently use Filemaker Pro 12 Advanced. Thanx.
There is a semi-colon inside of the double-quotes, after the word THOUSAND.
Ah, blind baby!! That was exactly it! Thanks so much.
Retrieving data ...