title: how to add date after text in a cell
body: <p>I have a cell <strong>B8</strong> that is currently formatted with the <em>Currency Format</em>, in a sheet that we will simply call <strong>Sheet1</strong>. I am sure this is something that I will need to accomplish in VBA, but what would be the process of having Excel add the following to the end of the cell B8:</p>
  
  <p><code>as of 'MM/DD/YY'</code> where the date is today (not concerned if the date auto updates or not, such as if I were to save the workbook after VBA entering today's date and if I were to reopen tomorrow it could either show the original date or the new date - does not make a difference as it will get saved in a non editable format)</p>
  
  <p>So with consideration that the cell is formatted with the Currency format (which excludes decimals btw), by me entering a number such as "<strong>10000</strong>", the cell should display the following:</p>
  
  <pre><code>$10,000 as of 03/03/16
  </code></pre>
  
  <p>Any suggestions?</p>