Spelling out a number

[jdulac]

Is there a function that will spell out the number. For example I have a number field with '5' and I want it displayed as "five". Or do i have to make my own formula?

 

[BobSuruncle]

Try using the ToWords() funtion.
It's described in the Help file.

Bob Suruncle

 

[synapsevampire]

Try:

towords({table.field},0)

This assumes no decimals.

-k

 

[jdulac]

Thanks guys. I had to change the field to a number using the "val" command but than the "toword" worked for what I was looking for.

 

[synapsevampire]

Then you should have posted that you have a string field with the number 5, not a number field.

If you give bad info, you won't get the proper response.

-k