 |  |  |  |  |  |  |  |
problem with decimal places
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved |
The following code comes up with a number that has 13 digits past the decimal point. How can I cut this down to 2 decimal places?
[Let drivetimeexpense = (rstdrivinginfo.timefromhome * rstdrivinginfo.numberoftrips * 2 / 60) * 20]
[Let drivetimeexpense = (rstdrivinginfo.timefromhome * rstdrivinginfo.numberoftrips * 2 / 60) * 20]
•
•
Join Date: Dec 2006
Posts: 79
Reputation: 
Solved Threads: 4
Junior Poster in Training
Where do you want it cut down? For display, many things such as texboxes have a way to number format data.
Then there's the Format function.
http://www.samspublishing.com/librar...eqNum=154&rl=1
As a very last resort, you basically multiple the number by 100, truncate to int, then divide by 100. But that's VERY old school, and assumes for some reason you don't have any of the normal string and number formatting functions available.
Then there's the Format function.
http://www.samspublishing.com/librar...eqNum=154&rl=1
As a very last resort, you basically multiple the number by 100, truncate to int, then divide by 100. But that's VERY old school, and assumes for some reason you don't have any of the normal string and number formatting functions available.
Google is your friend. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
Bored? Visit http://www.kaelisspace.com/
Bored? Visit http://www.kaelisspace.com/
•
•
•
•
Originally Posted by nikkiH 
Where do you want it cut down? For display, many things such as texboxes have a way to number format data.
Then there's the Format function.
http://www.samspublishing.com/librar...eqNum=154&rl=1
As a very last resort, you basically multiple the number by 100, truncate to int, then divide by 100. But that's VERY old school, and assumes for some reason you don't have any of the normal string and number formatting functions available.
 |
Similar Threads
- Two Decimal Places (VB.NET)
- Problem with memory allocation =( (C)
- C++ question(Decimal places)very weird (C++)
- Excel97 decimal places (Windows Software)
- Double values with two decimal places (C++)
- help with program (C++)
- I need special stuff in my project like system("cls") (C++)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: problem with mscomm
- Next Thread: gamepad in vb?
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
6 429 2007 access activex add age append application basic beginner birth c++ calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
