Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Significant digits, rounding

Status
Not open for further replies.

philsky

Programmer
Sep 21, 2001
8
US
I have several numeric fields on a report that I want to display with 3 significant digits. A number such as 12.34567 should appear as 12.3, whereas 0.98765 should appear as 0.988. Furthermore, integers should be displayed as is - i.e. 12 should display as 12.

I have found no way to define a numeric format to do this. When I specify 3 decimal places, then all the numbers have 3 decimal places. For instance:

Value Display
12.34567 12.346
12 12.000
0.35 0.350

Is there a way to do this? Thanks!!

Phil
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top