Print Page | Close Window

Suppressing zeros on right of decimal

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=85
Printed Date: 16 May 2024 at 6:15pm


Topic: Suppressing zeros on right of decimal
Posted By: ajb2007
Subject: Suppressing zeros on right of decimal
Date Posted: 03 Jan 2007 at 6:34am
I would like to display 4 or 5 decimal places when number is present
like  0.12345    butdisplay only 3 decimal places when there is only  3 like 0.123
 
thanks
 


-------------
ABOBBY


Replies:
Posted By: WLWes
Date Posted: 12 Jan 2007 at 1:30pm
CDbl (CStr ({number},"########.#####"))


Print Page | Close Window