title: Rename worksheet to cell value while keeping the format
body: <p>I am trying to rename a worksheet in VBA. I need to name it like 'yymmdd' for ex.: 150212 should be the name of the worksheet. I have written the below mentioned code but when the code tries to rename the worksheet then it does not pick up the value in the format 'yymmdd'. VBA gives me an error that the name cannot contain /. I need a way out so that the name of the worksheet becomes 'yymmdd'. </p>
  
  <pre><code>Range("G1").Value = Date
  Range("G1").NumberFormat = "yymmdd"
  Sheets("Fund Flow").Name = Range("G1").Value
  </code></pre>