title: How to convert a date to a string in Google Sheet
body: <p>I am trying to figure out how to convert a date into a string in a google sheet.</p>
  
  <p>I have one date field that has varying formats. I want create another column that's literally just the same but as a text. For example, if I had the following data</p>
  
  <pre><code>date       date_as_string
  12-05-2016 '12-05-2016
  12/5/2016  '12/5/2016
  2016-12-10 '2016-12-10
  </code></pre>
  
  <p>Where the ' is just to denote that it is a string note a date.</p>