title: Excel range usage question (cell error checking)
body: <p>I have the following error for every cell:
  "the number in this cell is formatted as text or preceded by an apostrophe"
  To duplicate the error:
  I have to store this results that come from a Web services as strings array:
  Sample: (3 by 3 array)</p>
  
  <p>$402,568.03 26.2%   30,052</p>
  
  <p>$107,719.59 7.0%    55,176</p>
  
  <p>$81,370.35  5.3%    54,365</p>
  
  <p>let values be the string array holding sample (string[,] values)
  Let  r be the range to target (Excel.Range r)
  If I do:
  r.Value2 =  values;</p>
  
  <p>I would like to know how to get rid of it. Any .net code will be great (C# or VB.NET)</p>
  
  <p>Note:
  1) Looping in every cell is not an option as the array can be quite big (100, 54) or (1024, 104). I have done and it does not have this error but the performance is very bad.</p>
  
  <p>2) Disable the errors is not an option, because I do not have control over the client settings.</p>
  
  <p>3) I notice that I use the conver to number context menu fix the issue, but it is possible to do it for the affeccted range programmatically.</p>