Author: Stelmerfudd | Posted on: 8/14/2008 3:57:22 PM | Views : 510

Hi,

I'm
having a problem formatting datagrid footer values to a number. When I
debug I can see that the value of grdTotals.Items.Item(i).Cells(n).Text
is "1,903" which is the formatting that I'm trying to achieve but when
I get past e.Item.Cells(n).Text = String.Format(x(n), "##,###") the
value is 1903. I've tried every trick in the book to format and I can't find anything that works.

Thank you for any suggestions.

Richard

Dim x(n) As Integer
  For i = 0 To grdTotals.Items.Count - 1
      For n = 1 To grdTotals.Items.Item(i).Cells.Count - 1
          x(n) += grdTotals.Items.Item(i).Cells(n).Text
          e. ...

Go to the complete details ...