I am having problems with my DataGridView.

I have two colums in this row. Text, and Cost. In the cost Column, I have the DefaultCellStyle Format set to C2 (As a number).

When I add rows (DataGridView.Rows.Add("Text", "5")), it formats it correctly as $5.00 (In the Cost Column).

The problem I am having is on an update. I want to be able to format the row correctly when a user edits the row. When I edit the row, DataGridView_CellEndEdit shows me the value "5", but not the correctly formatted value, nor can I update the format for the user.

How would I update the format?