title: Spire Xls set cell range hexadesimal format
body: <p>I am using Spire Xls with c#, to create an Excel document. The problem is with one of my columns, that is an hexadesimal string. In most cases the cells of the columns are ok, but, when the hexadesimal string contains only numbers (and the 'E' character) then, those cells appear in number format</p>
  **<p>Example:</p>**
  92995E85 (original string) -> 9.2995E+89 (cell result)
  <p>I want to keep the original string in the cell.</p>
  <p>This is my code:</p>
  <pre><code>Workbook workbook = new Workbook();
  workbook.Version = ExcelVersion.Version2013;
  
  var ws = workbook.ActiveSheet;
  ws.InsertDataTable(report, true, 1, 1);
  
  for (int i = 1; i &lt;= 9; i++)
      ws.AutoFitColumn(i);
  
  using(var fs = new FileStream(options.ReportPath.Trim(), FileMode.Create)) {
      //cerrar bien el filestream para q escriba a disco
      workbook.SaveToStream(fs);
      workbook.Dispose();
  }
  </code></pre>
  <hr />
  <blockquote>
  <p>The <code>report</code> variable is a <code>DataTable</code> with the problematic column as string.</p>
  </blockquote>