title: Writing string, numeric data to Excel via C# works, but Excel does not treat numeric data correctly
body: <p>I'm getting result sets from Sybase that I return to a C# client.</p>
  
  <p>I use the below function to write the result set data to Excel:</p>
  
  <pre><code>private static void WriteData(Excel.Worksheet worksheet, string cellRef, ref string[,] data)
  {
       Excel.Range range = worksheet.get_Range(cellRef, Missing.Value);
  
       if (data.GetLength(0) != 0)
       {
           range = range.get_Resize(data.GetLength(0), data.GetLength(1));
  
           range.set_Value(Missing.Value, data);
       }
  }
  </code></pre>
  
  <p>The data gets written correctly.</p>
  
  <p>The issue is that since I'm using string array to write data (which is a mixture of strings and floats), Excel highlights every cell that contains numeric data with the message "Number Stored as Text".</p>
  
  <p>How do I get rid of this issue?</p>
  
  <p>Many thanks,
  Chapax</p>