When I copy values from a data table to an Excel sheet, the leading zeros disappear. This is most likely a result of Excel seeing the values as numbers rather than text.
I am copying the values like so:
myWorksheet.Cells[i + 2, j] = dtCustomers.Rows[i][j - 1].ToString();
How do I format a whole column or each cell as Text?