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.

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.