Help me with some fn in vb/vba...

[dmanojkmr]

hey i need to know how to get a value with 2 decimals..

i tried with e.g a = 3.102 round ( a,2) i get the value as 3.1 and not as 3.10...i want to get the value as 3.10 ..how can i make it..??

[westconn1]

to show leading or trailing zeroes you must display the value as a string, using format command

[kaliman79912]

Or you could format the cells with a number format. If you need the value to actually round because you are going to perform operations with it then use the formula you posted and format the cell as number. But if you only need it to display with 2 decimals and do not care if the actual value has more precision then just format the cell and leave the number as is.

[dmanojkmr]

hey leave off excel...i am using MicroStation (a drafting software for Mech Engineers ). I actually want a VB code.
a= 3.100
b=round(a,2)
msgbox(b)

I should get the value in msgbox as 3.10

now what shall i do....I can't use any excel worksheet functions here ...

[dmanojkmr]

i tried with this Math.Round (3.102, 2) but still i din get desired result

[dmanojkmr]

b = Format(Round(3.102, 2), "#0.00")

Thank You Guys this works fine

[kaliman79912]

hey leave off excel...i am using MicroStation (a drafting software for Mech Engineers ). I actually want a VB code.
a= 3.100
b=round(a,2)
msgbox(b)

I should get the value in msgbox as 3.10

now what shall i do....I can't use any excel worksheet functions here ...

Then you posted in the wrong forum

[westconn1]

Then you posted in the wrong forum

AFAIK this is the correct forum for all vba and other application automating

b = Format(Round(3.102, 2), "#0.00")

you do not need to round the number, if you only need the 2 digit decimal for display purposes, the format will do that
round returns a value,
format returns a string

[dmanojkmr]

oh fine....but if i need the value of 3.167 as 3.17 will the format function round it's value...??? i suppose it just displays the result as 3.16

[opus]

correct, in your case you need Round and Format. Format since you need a display of "3.00"!