Hold Decimals in String

[SteveK88]

Hi,

I am passing WorkPoint locations to a text file.

When the values get passed across I get whole numbers and decimals.  I'd like to keep all with 2 place decimals. 

Simplified,

roundedClosest = CStr(Round(5, 2))

Results in a text value of 5

Preference is to be 5.00

Any ideas?  

[bradeneuropeArthur]

in:

• Ilogic?
• VBA?
• VB.net?
• or else?

[bradeneuropeArthur]

With VBA:

Public Sub Stringdec()

Dim a As Variant
a = 5.1233

Dim b As Variant
b = VBA.Round(a, 0)

'MsgBox b & ".00"

Dim e As Variant
e = b & ".00"

MsgBox e
End Sub

[SteveK88]

I'd like to stay in iLogic.

---

@bradeneuropeArthur wrote:

in:

• Ilogic?
• VBA?
• VB.net?
• or else?

---

[SteveK88]

Thanks, but this will change all decimals numbers to whole numbers.  I have a mix,

number from Inventor WorkPoints can be 5, or 5.123458.  Looking to get two place decimals in my string at all times.

5.00, 5.12 - preferred

Presently using iLogic rounding I get,

5, 5.12 - not preferred

I would like to stay in iLogic.

[lmc.engineering · Accepted solution]

Hi @SteveK88

This should work for you.

Version:1.0 StartHTML:00000145 EndHTML:00000623 StartFragment:00000294 EndFragment:00000591 StartSelection:00000294 EndSelection:00000294SyntaxEditor Code Snippet

myParameter = Double.Parse(x1).ToString("0.00") 

[lmc.engineering]

sorry, the x1 in brackets is your input