title: Converting a date to text in VBA
body: <p>I have a data set that includes values as text such as "March 2016".</p>
  
  <p>Now I have written the following code to replicate this in my report sheet: </p>
  
  <pre><code>DataFin.Range("E9:E9") = DateSerial(Year(Date), Month(Date), 0)
  DataFin.Range("E9:E9").Text = Format(DateSerial(Year(Date), Month(Date), 0), "mmmm yyyy")
  </code></pre>
  
  <p>It has the correct format, but when I click on the cell the value states "3/1/2016" instead of "March 2016". </p>
  
  <p>Any ideas how I can change the underlying value to "March 2016"</p>
  
  <p>Thanks,</p>
  
  <p>Pete</p>