title: How to get formatted display cell value in excel using closedXML?
body: <p><a href="https://i.stack.imgur.com/xn8SH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xn8SH.png" alt="enter image description here"></a>I would like to get the displayed value in excel, not the rich text, but the formatted display value.</p>
  
  <p>For example, if the value is "7/1/2015", and this cell is with number format:<code>cell.Style.NumberFormat.Format="d"</code>, then in excel this number will be displayed as 1.</p>
  
  <p>I would like to get the "1" by using closedXML but with no success. Below are some value I tried:</p>
  
  <pre><code>cell.Value = "7/1/2015";
  cell.RichText.Text = "7/1/2015";
  cell.GetString() = "7/1/2015";
  cell.GetFormattedString() = "7/1/2015";
  cell.GetValue&lt;string&gt;() = "7/1/2015";
  </code></pre>
  
  <p>Does any one know how to achieve this?
  Many thanks!</p>