Print Page | Close Window

Number to Text Syntax (no currency) Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Technical Questions Forum Discription: Formulas, charting data, Crystal syntax, etc. URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22406 Printed Date: 30 Apr 2024 at 4:17pm Topic: Number to Text Syntax (no currency) Posted By: Becantor Subject: Number to Text Syntax (no currency) Date Posted: 07 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 Replies: Posted By: kevlray Date Posted: 08 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 Date Posted: 08 Aug 2017 at 7:56am Thanks. Adding the ,0 to the end di.d the trick

Print Page | Close Window