Amount (in word) format

[EngJoo]

Greeting,

does anyone can guide what is the syntax for converting a amount to WORDS?

for example:

935 = nine hundred thirty-five only

Thanks
EngJoo

 

[DallasAggie]

What version of Crystal?

Version 9 has : ToWords() That you can use...not sure if available in prior versions.

 

[Madawc]

The ToWords command will automatically turn a whole number into words. Say ToWords({Your.Amount}). For whole numbers this is OK: 4,304 becomes four thousand three hundred four.

Decimals - normally used for currency - are a different matter . ToWords({Your.Amount},2) for 4304.34 will give you four thousand three hundred four and 34/100. For zero pence it would be and xx/100. (This is Crystal 8.5: later versions may be better.)

You can get a much neater look using something like:

if Truncate({Your.Amount}) = {Your.Amount}
then
ToWords({Your.Amount}) & " pounds exactly" 
else
ToWords({Your.Amount}) & " pounds, "  &
Towords(Tonumber(Right(totext({Your.Amount}, 2), 2))) & " pence"

ToWords has been available since at least Crystal 8.5, which I used to use.

Madawc Williams (East Anglia, UK)