Can anyone help me HOW TO round up a decimal number up to 2 digits.

eg. from 1374.46 -------------> 1375.00

TQ in advance...

response.Write FormatNumber(round(1374.46),2,,,0)
This will round to 1374 and not 1375

Om Prakash

ops sorry, I did not see the previous reply
Marco

Try this function. It will take any number with a decimal after it, truncate it, and add one

    Public Shared Function roundUp(ByVal iNum As String) As Integer
        If Not IsDBNull(iNum) Then
            Dim sStr As String = iNum
            If InStr(sStr, ".") > 0 Then
                Return CInt(Left(iNum, InStr(sStr, ".") - 1)) + 1
            Else
                Return iNum
            End If
        Else
            Return 0
        End If
    End Function


mark