I am using an Infragistics Ultragrid to display an accounts ledger. The grid has a detail column, a debit column and a credit column. The monetary values have to be formatted and I am setting this within the InitializeLayout event as follows: e.Layout.Bands(0).Columns(2).Format = "£#,##0.00". This works fine.
However, each row will have either a zero debit value and a nonzero credit value or a nonzero debit value and a zero credit value. The problem is that the zero values are showing as £0.00 in the cells but the users want the cells to be blank if the value is zero.
What's the best way of doing this?