title: Datagridview customization and formatting
body: <p>I have a datagrid and a datatable . Values in datagrid came from datable. Now the cell values is in <code>decimal</code> and I want to change the format to 2 decimal places but here's my problem not all cell values is integer also it contain <code>STRING VALUE</code> like <code>N/A</code>.</p>
  
  <p>Here's my sample datagrid filled with data:</p>
  
  <pre><code>Name    |   Col1        |   Col2        |
  -----------------------------------------
  xxx     |   N/A         |    N/A        |
  yyy     |   12.1999999  |    23.012355  |
  zzz     |   0.12366666  |    12.357878  |
  </code></pre>
  
  <p>I already tried </p>
  
  <pre><code>datagrid.columns(1).DefaultCellStyle.Format = "N2"
  datagrid.columns(2).DefaultCellStyle.Format = "N2"
  </code></pre>
  
  <p>but the cell values didn't change the format, I know the problem there is the cell value contain string. There is other way to bypass that string?</p>