title: VB.net DataGridView change Cell.FormattedValue
body: <p>how do I change the string/value (cell.FormattedValue), which appears in EditMode after user double clicks a cell?</p>
  
  <p>I.e. the value is "5", formated value is "5 pcs" and this is causing error on validation. So I wan't to replace the string which appears to user from "5 pcs" back to "5". 
  Then it should work the same way like when user simpy starts to write "5" and presses Enter.</p>
  
  <p>This is not possible, FormattedValue is ReadOnly:</p>
  
  <pre><code>Me.dgwNest1.Rows(e.RowIndex).Cells(e.ColumnIndex).FormattedValue = 5
  </code></pre>
  
  <p>Cell.Value is not usable, as it only changes the value portion of edited string.</p>
  
  <p>Regards,</p>
  
  <p>Libor</p>