title: VBA Paste Calculated Value as Date or Currency
body: <p>I am using the following vba code to calculate a number from another cell, but when the result is posted in cell B4, it doesn't show a dollar sign currency. I cannot set a range because this is set up to fall on the next available line. I also have a similar calculation that I need shown as a date but it shows as a numerical value.</p>
  
  <p>Sheet2.Range("B4") = Sheet2.Range("B3") * 12</p>