I have a asp grid contents generated dynamically using a sql procedure.

using the procedure datatable returned is binded to the grid. In this grid i have a cost column which I like to round to 4 decimal places(12.1234). How to do the same?

I tried in RowDataBound as

```
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[4].Text = string.Format("{0:N4}", e.Row.Cells[4].Text);
}
```

But this has no effect. I cannot apply the formatting to datatable as I am using this for cost calculations so rounding the cost could cause problems.

Any help will be appreciated