Hi,

Anyone outthere has a tool to translate a number value to word value?

e.g. $500 translate to "Five Hundred Dollars"

Thanks,

Garry

You can wright script which does it.

Or create calculation. It is not so difficult.

If it's not so difficult aaa, you should post one.

Garry, since you have Dev 7, you can use a custom function to do this. Luckily, others have already done this. Check out ParseCurrency() on Brian Dunning's site:

http://www.briandunning.com/filemaker-custom-functions/detail.php?fn_id=22

This question comes up from time to time. I just did a search for +number +Text +format and got over 200 hits.

Search = [color:"blue"] All Forums

Keywords = [color:"blue"] +number +Text +format

Weeks = [color:"blue"] 0

Take a look at this one for sure, as it has some great calculations: Posted by LaRetta

HTH

Lee

Thanks Ender, ParseCurrency() works just as I want it. Great Custom fuctions on that site you referred.

-garry

HI garrys,

Oh, oh. Something had gone wrong with the link I had posted, and it didn't work. [color:"blue"] I fixed it, and It works now.

Sorry for any inconvenience.

Lee

Thanks lee for correcting the link. I got the site now.

-garry