Jun 21, 2006 #1 polash Programmer Mar 28, 2001 13 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 Jun 7, 2000 278 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 Mar 28, 2001 13 SG Paul, Thank you very much Upvote 0 Downvote
Jun 21, 2006 #4 strongm MIS May 24, 2001 20,188 GB But be aware that the Round function does financial rounding rather than mathematical rounding Upvote 0 Downvote
Jun 21, 2006 #5 gmmastros Programmer Feb 15, 2005 14,905 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