0

hi,

can anyone assist me on this...i want to convert 100 to 1.00 for example
100 = 1.00
200 = 2.00
1000 = 10.00
How do i do that. Please help me.

2
Contributors
2
Replies
4
Views
7 Years
Discussion Span
Last Post by swathys
0

You need to parse in the value you want as a string, apply the formatting, then return the value as a string so that it shows the decimal places.

Private Function calc(ByVal valueIn As Double) As String

        Dim newValue As String

        newValue = Format(valueIn / 100, "0.00")

        Return newValue

    End Function

I hope this helps.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.