I had given the format as e.Layout.Bands(0).Columns("Loan Amount").Format = "$#,##0.00"

but the problem here is if the value is negative it is showing like -$20,000 but it supposed to show like ($20,000)

Then you need to account for that in your Format. The Format property just calls ToString on the Value of the cell and passes in the format you specified. So check out the Microsoft documentation on the formats available for the data type of your column. I'm pretty sure that most numeric types allow you to specify different formats for positive, zero, and negative numbers separated by a semi-colon.

I was using sortcomparer class. I had created one hidden column and applied -1 value for nulls. On header click my original column sorts according to the hidden column.

Public Class LMSSortComparer
    Implements IComparer
    Public Function Compare(ByVal x As Object, ByVal y As Object) As Integer Implements System.Collections.IComparer.Compare
            Dim xCell As UltraGridCell = DirectCast(x, UltraGridCell)
            Dim yCell As UltraGridCell = DirectCast(y, UltraGridCell)
            If xCell.Column.Key = "Current Rate" Or xCell.Column.Key = "Rate" Or xCell.Column.Key = "Percentage Rate" Then
                Return Decimal.Compare(DirectCast(xCell.Row.Cells("sortRate").Value, Decimal), DirectCast(yCell.Row.Cells("sortRate").Value, Decimal))
            End If

How did you manage to show NA dfifferent from 0 ??
I Just knwo format string handels 3 states i.e. +ive number negatiev number and Zero, hows Null handeled ??
Say i use nullable int in Grid (int?)

Thanks very much.

 No I was asking you that is there any Infragistics help topics that explains each property in the software installed(Infragistics).