Formatting datagridview cell to 2 decimal places

Question

Basically I have a datagridview which displays data from a datatable. Each cell in the datatable is a decimal with roughly 10 decimal points, how can I use the datagridview to display this data to 2 decimal points?

I have tried this (what I found in other questions):

        for (int i = 0; i < this.dgvDynamics1.Columns.Count; i++)
            this.dgvDynamics1.Columns[i].DefaultCellStyle.Format = "N2";

but it doesn't work

If you need any more info let me know

Thanks in advance

Answer 1

Try this:

this.dgvDynamics1.Columns.Items[i].DefaultCellStyle.Format = "0.00##";
this.dgvDynamics1.Columns.Items[i].ValueType = GetType(Double)

Answer 2

try this

private void dgvList_CellFormatting(object sender,DataGridViewCellFormattingEventArgs e)
    {
        if (e.ColumnIndex == 6 || e.ColumnIndex == 8)
        {
            e.CellStyle.Format = "N2";
        }
    }