Nyx Assasin Nyx Assasin - 1 year ago 138
Vb.net Question

Display Data with Format in Datagridview

Lets say you have a column in Datagridview that has Negative and Positive Numbers that act as a data.

How can you display numbers with negatives into Open and Close Parenthesis?
For example -5.00 will turn to (5.00)

How can I achied that? TYSM

Answer Source

You can set the default format for that column:

DataGridView1.Columns(n).DefaultCellStyle.Format = "#,##0.00;(#,##0.00)"

Some further info on formatting can be found here.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download