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 Chriss 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
Joined
Sep 21, 2001
Messages
8
Location
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