Jun 21, 2006 #1 polash Programmer Joined Mar 28, 2001 Messages 13 Location SG I want to convert 23.43535353 to 23.44 like this in VB6. Can any body help me in this regards. Thanks in advance. Polash
I want to convert 23.43535353 to 23.44 like this in VB6. Can any body help me in this regards. Thanks in advance. Polash
Jun 21, 2006 #2 NFI Programmer Joined Jun 7, 2000 Messages 278 Location GB Use the ROUND function... round(number [,decimal_places]) so... round(23.43535353,2) returns 23.44 Paul Upvote 0 Downvote
Use the ROUND function... round(number [,decimal_places]) so... round(23.43535353,2) returns 23.44 Paul
Jun 21, 2006 Thread starter #3 polash Programmer Joined Mar 28, 2001 Messages 13 Location SG Paul, Thank you very much Upvote 0 Downvote
Jun 21, 2006 #4 strongm MIS Joined May 24, 2001 Messages 20,264 Location GB But be aware that the Round function does financial rounding rather than mathematical rounding Upvote 0 Downvote
Jun 21, 2006 #5 gmmastros Programmer Joined Feb 15, 2005 Messages 14,912 Location US This page does a decent job of explaining bankers rounding. http://support.microsoft.com/?kbid=196652 Who knew that rounding would be some complicated. -George Strong and bitter words indicate a weak cause. - Fortune cookie wisdom Upvote 0 Downvote
This page does a decent job of explaining bankers rounding. http://support.microsoft.com/?kbid=196652 Who knew that rounding would be some complicated. -George Strong and bitter words indicate a weak cause. - Fortune cookie wisdom