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!

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

Decimal Places

Status
Not open for further replies.
stvnkrs

stvnkrs

Technical User
Sep 17, 2001
16
US
I have a report with calculated fields (sales per hour which divides sales by hours). I have the text boxes set as Fixed format, 2 decimal places. But in the report preview/printout it still shows many decimal places (1.3234234). Any suggestions? Thanks!
 
Sort by date Sort by votes
Hi!

Try using the currency format, though that will add a $.

hth
Jeff Bridgham
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rstrong
  • Locked
  • Question
Changing textbox's decimal places on report open
Replies
1
Views
62
Remou
Remou
Trudye
  • Locked
  • Question
Can't get rid of decimals places
Replies
1
Views
37
Trudye
Trudye
klmack
  • Locked
  • Question
Simple Calc in Report produces wrong decimal places 1
Replies
2
Views
41
klmack
klmack
jkirkland
  • Locked
  • Question
Custom Format (Decimal Places)
Replies
1
Views
41
Blorf
Blorf
handlebarry
  • Locked
  • Question
Decimal places on export to excel
Replies
3
Views
92
Remou
Remou

Part and Inventory Search

Sponsor

Back
Top