mysql - Display Data with Format in Datagridview

Question

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 1

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.