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!

format decimal places 2

Status
Not open for further replies.
MikeT

MikeT

IS-IT--Management
Feb 1, 2001
376
US
I need to format a number so it displays out to the fifth decimal place.
Also, if I tell to 3.49999 to display out to the 2nd decimal place, will it show 3.50 or 3.49?
Thanks!
 
Sort by date Sort by votes
you can use the formatNumber(number, 5) function to get your desired results. number being the argument, and 5 being how many places you want the result to show.

And yes, if you ask for two decimal places on 3.499999, then you will get 3.50 --

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
decimal field
Replies
1
Views
111
xwb
xwb
elly00
  • Locked
  • Question
format number with 2 decimal 1
Replies
2
Views
157
iambob
iambob
elly00
  • Locked
  • Question
decimal separator
Replies
1
Views
115
xwb
xwb
lpeder6
  • Locked
  • Question
modifying and formatting microsoft word document
Replies
5
Views
183
SkipVought
S
JC_123
  • Locked
  • Question
VBS and formatting using bold or colours
Replies
4
Views
262
JC_123
JC_123

Part and Inventory Search

Sponsor

Back
Top