title: C# Excel Interop: How to format cells to store values as text
body: <p>I'm writing numbers to an Excel spreadsheet from a <code>DataTable</code> and all of these numbers are 5 digits long with preceding 0s if the number itself is less than 5 digits long (so 395 would be stored as 00395, for example).</p>
  
  <p>When entering these numbers into Excel (using C#), it's storing them as numbers and eliminating the preceding 0s. Is there any way I can format the cells from C# in order to get the values to be stored as text rather than numbers? </p>