CRYSTAL REPORT -CONVERT NUMBERS TO WORDS WITH AND WITHOUT DECIMAL PLACES 1

[DJSHWEIZ]

I am converting numbers to words using formula TOWORDS(X). The formula works fine when I have decimal places e.g. 500.59 it reads five hundred and 59/100. This is exactly what I wanted. but when I have numbers without decimal places, for example in 500 am getting five hundred and xx/100. is there a way I can remove xx/100 where I don't have decimal places but get 59/100 format when i have decimal places?

 

[pmax9999]

Hi DJSHWEIZ

Change your formula to this:

Replace(ToWords({Table.Field}), 'and xx / 100', '')

Hope this helps.

Cheers
Pete

 

[DJSHWEIZ]

Worked like magic. Thank you so much

 

[DJSHWEIZ]

Worked like magic. Thank you so much Pete