Translating number value to word value

[garrys]

Hi,

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

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

Thanks,

Garry

[aaa]

You can wright script which does it.

Or create calculation. It is not so difficult.

[Ender]

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

[Lee Smith]

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

[garrys]

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

-garry

[Lee Smith]

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

[garrys]

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

-garry