Number Format in DataBoundGrid

[Satish]

Clay,
I have set format like "#,###.00(#,###.00)" for one my number column.

If the user enters the say -10000, and moves to the another cell. the value -10000 will be displayed like (10,000).

Now if user wants to edit that cell again, i want the value in the cell should be displayed like the one user entered i.e. -10000 not the formatted one (10,000)

So how to achieve this?

Thanks
Satish

[Administrator]

You can handle the CurrentCellInitializeControlText event and do it there.

Private Sub gridControl1_CurrentCellInitializeControlText(ByVal sender As Object, ByVal e As GridCurrentCellInitializeControlTextEventArgs)
     If e.RowIndex = 1 And e.ColIndex = 1 Then
          Dim d As Double = e.CellValue
          If d < 0 Then
              e.ControlText = d.ToString()
          End If
      End If
End Sub