[RESOLVED] Convert a floating-point no. to its true/complete numeric value

[Ellis Dee]

Im not sure if I understand, you mean just this?

Private Function GetMiltiply(pNumber1 As Double, pNumber2 As Double) As String
    GetMiltiply = Format(pNumber1 * pNumber2, 0)
End Function

MsgBox GetMiltiply(1.23456789123457E+107, 9.87654321987654E+107)

No, he wants the actual values. Doubles are only approximations. For example:

Public Sub Test()
    Dim dblNumber As Double
    
    dblNumber = 1.23456789123457E+107
    If dblNumber + 1 = dblNumber Then MsgBox "Epic Fail"
End Sub

It's never a good thing when your math ends up showing that a + 1 = a.