How to round off to only two decimal places?

[neo008]

Hi all,

I am using some variables as "Double" and some text boxes set "DataFormat" property to "Number with two decimal points" for currency calculations.

I perform some typical mathematical operations on them and in some cases I see result having more than two decimal points.

How can I restrict or round-of to only two decimal places.

I'm using VB6.

NE☼

[Killer42]

You'll most likely want to use the Format() function. There are a few possbilities; you may need to play around with it. You can try the named formats "Fixed" or "Currency", or make up your own format. Example: Format(123.456,"Fixed") shows "123.46" (rounded up).
Some formats such as "Currency" depend on your regional settings.

[neo008]

You'll most likely want to use the Format() function. There are a few possbilities; you may need to play around with it. You can try the named formats "Fixed" or "Currency", or make up your own format. Example: Format(123.456,"Fixed") shows "123.46" (rounded up).
Some formats such as "Currency" depend on your regional settings.

Thanks Killer42


Exactly same way we can define decimal places also in "Number" format, an optional -ve sign is also there.It works also fine I believe.
If you give an integer to it, it'll add two 0s at end of it.

In my case a recursive process is updating text field and result is 7-10 decimal places occur. I think it may be a reason it automatically jumps out of the format defined.

I can round-off upto 2 decimal places in code but I dont want to if it can be done automatically.


NE☼

[superjen26]

this is exactly what I'm looking for, Thank You, it worked!