title: Excel TEXT formula doesn't convert 'yyyy' to a year
body: <p>I want to combine some text with a date in Excel 2013.</p>
  
  <p>Let's say I have a cell A2 with a date like <em>30-10-2014</em>. I tried to append the date after the text with this formula:
  <code>="Some text and a date: "&amp;A2</code></p>
  
  <p>But the output shows the date as a number: <em>Some text and a date: 41942</em></p>
  
  <p>So I tried it with the <a href="https://support.office.com/en-us/article/TEXT-function-20d5ac4d-7b94-49fd-bb38-93d29371225c?ui=en-US&amp;rs=en-US&amp;ad=US" rel="noreferrer"><code>TEXT</code></a> formula:
  <code>="Some text and a date: "&amp;TEXT(A2;"dd-mm-yyyy")</code></p>
  
  <p>But this shows <em>Some text and a date: 30-10-yyyy</em> and not <em>Some text and a date: 30-10-2014</em></p>
  
  <p>So or I do not understand how the <code>TEXT</code> formula works or is there some bug / issue here?</p>
  
  <p><strong>UPDATE</strong>: It looks like it's important that I have a Dutch version of Windows (7) but an English version of Excel (2013) which causes this issue!</p>