Round off to no decimals without comma

[sso_enerdry]

I have a short Ilogic, that rounds of my mass on my parts/assemblies as follows:

If iProperties.Mass<0.1 Then
iProperties.Value("custom", "Rounded_Mass") = Round(iProperties.Mass, 3)
ElseIf iProperties.Mass<1 Then
iProperties.Value("custom", "Rounded_Mass") = Round(iProperties.Mass, 2)
ElseIf iProperties.Mass<10 Then
iProperties.Value("custom", "Rounded_Mass") = Round(iProperties.Mass, 1)
Else If iProperties.Mass>10 Then
iProperties.Value("custom", "Rounded_Mass") = Round(iProperties.Mass, 0)
InventorVb.DocumentUpdate()

End If

The last Else If - when the mass is over 10 kg. I want it to show the mass without decimals.
This works, but it keeps writing e.g. "165," instead of "165"
How do I remove the comma?

Thanks in advance.

[blandb]

I copied your code into a part in 2019 and I dont get the comma.

[marcin_otręba · Accepted solution]

try cstr(Round(iProperties.Mass, 0)).Replace(",", "")

[bradeneuropeArthur]

@sso_enerdry

What version of inventor are you working with?

did you choose the Rounded_Mass as number or as text?

for me the code works fine with as number...

[sso_enerdry]

Hi Marcin

Your solution seems to work.

I also tried this, for the last line:

Properties.Value("custom", "Rounded_Mass") = Int(iProperties.Mass)

Which seems to solve the problem as well.

Thanks 

Soeren

[sso_enerdry]

hi Bradeneurope
I'm running Inventor 2018.

I've solved the problem by turning the rounded value into an integer.

It is a little funny though, that I couldn't get my first try to work

but thanks anyway

br

Soeren