Converting a date to text in VBA
<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>