DataGridView and currency formatting

[Jaco]

I'm trying to set up a currency value column in a DataGridView (2005) and I'm following examples from Microsoft on how to do this, but the currency formatting is being ignored.

Here's how the samples (from Microsoft) indicate how it's done:

 

Dim col As New DataGridViewTextBoxColumn()

col.DefaultCellStyle.Format = "C" 'also tried lower case "c", but no luck

... <other properties such as header text etc.> ...

MyGrid.Columns.Add(col)

 

But when values are set on that column, they appear as plain numbers, not currency (i.e., no '$', no comma, etc.).

[mjb3030]

Try this:

 

Dim col As New DataGridViewTextBoxColumn()

col.DefaultCellStyle.Format = "C"

col.ValueType = GetType(Double)

MyGrid.Columns.Add(col)