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]

Recommended Answers

All 2 Replies

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/library/content.asp?b=STY_VB6_24hours&seqNum=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.

commented: very helpful +1

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/library/content.asp?b=STY_VB6_24hours&seqNum=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.

Thanks!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.