C# - Decimals not writing out to Excel
<p>I have an ETL that's saving data to an Excel file. The issue is that the decimals are not being written out for integers. Example:</p>

<pre><code>14.00
</code></pre>

<p>is being written out as </p>

<pre><code>14
</code></pre>

<p>My code for writing out that line is </p>

<pre><code>loWorksheet.Cells[liRowNum, 5] = lcAmount.ToString("0.00");
</code></pre>

<p>When I step through the code, it shows as 14.00, but on the Excel file it is not retaining the decimal places. Is this something that can be fixed in my code or is this an Excel issue? Any suggestions?</p>