How to Format and display currency?

Use the FormatString, FormatProvider and FormatType properties to specify custom format for the values displayed in the column.

[C#]

System.IFormatProvider format = 
  new System.Globalization.CultureInfo("en-US",true);
myDataGrid.Columns["Currency"].FormatProvider=format;
myDataGrid.Columns["Currency"].FormatType=typeof(System.Decimal);
myDataGrid.Columns["Currency"].FormatString="C";

[VB.NET]

Dim format As System.IFormatProvider = _
  New System.Globalization.CultureInfo("en-US", True)
myDataGrid.Columns("Currency").FormatProvider = format
myDataGrid.Columns("Currency").FormatType = (New System.Decimal).GetType()
myDataGrid.Columns("Currency").FormatString = "C"