How to convert a date to a string in Google Sheet
<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>