Number to Text Syntax (no currency)

Printed From: Crystal Reports Book — Forum Name: Technical Questions

Posted By: Becantor — 7 Aug 2017 at 12:34pm

Hi,

Looking for the proper way to convert 2000 to "Two Thousand" in a report. I have tried to use ToWords (), but this adds the currency syntax to the end (i.e. "Two Thousand and xx / 100" )

What is the syntax to use to JUST display the number spelled out without the current add on

Thanks

Posted By: kevlray — 8 Aug 2017 at 4:02am

I think there is an option to not display that. Try ToWords({somefield, 0). Help should always be available in CR

Posted By: Becantor — 8 Aug 2017 at 7:56am

Thanks.

Adding the ,0 to the end di.d the trick