I am trying to change the number format in a cell (a number is already there, entered by the user) of my DataGridView (unbound) after clicking a button, for example. Here is line of code in the button click event:

myDataGridView.Rows(0).Cells(0).Style.Format = "C2"

The problem is that the format (currency in this example) does not take effect.

The cell-formatting does not work with currencies and I do not know why. However, I found that if the variable you are posting to that particular cell is not in currency format (even in string type), it will not format properly. I had to force a format into a string before I could get the cell to actuall format properly.

Plus, you may want to preset the cell on the initialization of the grid. Hope that helps you!

Rafo of LTSE

Thanks for your input. I had to do the following to make it work. The default ValueType is "Object" and none of the numeric formats are applied until changed to "Decimal". I had to convert the string to a numerical value (single) also to make it take effect.

With myDataGridView.Rows(0).Cells(0)
     .ValueType = GetType(Decimal)
     .Style.Format = "C2"
     .Value = CSng(.Value)
End With