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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rounding to the thousandths position 1

Status
Not open for further replies.
uksub

uksub

Programmer
Jun 15, 2003
51
US
does anyone know how to round a money figure up to the thousandth's place?
 
Sort by date Sort by votes
If you right click your number field, and select the Customize option under Format/Number, you can specify your rounding and decimalisation per field by using the drop downs.

Naith
 
Upvote 0 Downvote
Round({YourNumber},-3) will round to the NEAREST thousand.

If you want to always round up, try this:

Round({YourNumber}+499.9999999,-3)


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
677
dgillz
dgillz
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
434
mmck1964
mmck1964
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
281
jchewsmith
jchewsmith
DennisY
  • Locked
  • Question
A subscript must be between 1 and the size of the array.
Replies
10
Views
327
DennisY
DennisY
AleXSR700
  • Locked
  • Question
How to find first non-zero decimal place?
Replies
8
Views
353
AleXSR700
AleXSR700

Part and Inventory Search

Sponsor

Back
Top