title: CSV date and separator issue
body: <p>I have a CSV file, delimited by comma and I have some date values inside it, like <code>"01/13/2010 05:00:00 AM"</code>, or <code>"04/01/2010 05:00:00 AM"</code>. The issue is that when I open the CSV file with Microsoft Excel, it will show these days as <code>01/13/2010 05:00:00 AM</code> and <code>04/01/2010  05:00</code>, respectively. The value of the second one is <code>04/01/2010  05:00:00</code>, but it still shows <code>04/01/2010  05:00</code>. I've made a few tests and I've realized that Excel is not able to determine which is the day and which is the month in a few cases. In fact Excel gets a string like:</p>
  
  <pre><code>__/__/____ __:__:__ __
  </code></pre>
  
  <p>It deduces from the last two characters (AM/PM) the value of hour, it knows what the minute and second is, also, it determines the year when it sees the four-character long number sequence, so the question is about month and day. If the first and the second number from the string are both &lt;= 12, then it can't determine which is the month and which is the year, so it messes up my date format.</p>
  
  <p>I would like to have a date format such as</p>
  
  <pre><code>MM/dd/yyyy HH:mm:ss AM/PM
  </code></pre>
  
  <p>and I've found out that using the function called TEXT is able to do just that, like this:</p>
  
  <pre><code>=TEXT("04/13/2010 05:54:00 AM", "MM/dd/yyyy HH:mm:ss AM/PM")
  </code></pre>
  
  <p>It works like a charm, but it still guesses which is the day and which is the month. However, assuming that the clients will have the same default date format as the data in the CSV, the month and the day won't be inverted. However, I don't want to open Excel and type the formula in, because I need to give this file to clients and it should show the right value whenever they open the file. So, I need to write the formula inside the comma-separated file, but... TEXT is two-dimensional and there is a comma separating my date from my format.</p>
  
  <p>If I type:</p>
  
  <pre><code>= ABS(-5),=TEXT("04/13/2010 05:54:00 AM", "MM/dd/yyyy HH:mm:ss AM/PM")
  </code></pre>
  
  <p>into my file, I will see 3 cells, the first being <code>5</code>, the second is <code>=TEXT("04/13/2010 05:54:00 AM"</code> and the third is  <code>"MM/dd/yyyy HH:mm:ss AM/PM")</code>.</p>
  
  <p>How can I prevent this behavior? Can I use something else instead of the comma inside my function call? Or can I change the separator? Or is there a better solution?</p>
  
  <p>Can you enlighten me, to learn how can I enter function calls inside a CSV file?</p>
  
  <p>Thanks in advance to everybody who tries to help,</p>
  
  <p>Lajos Árpád.</p>