Reading digit values from excel sheet
<p>In my excel sheet i have one column contain digits.
Like: </p>

<pre><code>  500

  10,973.14

  12,456.23
</code></pre>

<p>when i read i got values
like: </p>

<p>500</p>

<p>10,973.141</p>

<p>12,456.2345</p>

<p>Let me know how to read values what ever appearing in excel sheet.</p>

<p>Output :</p>

<p>500</p>

<p>10,973.14</p>

<p>12,456.23</p>

<p>i used oledbconnect. code like ;`</p>

<pre><code>              for (i = 0; i &lt; accountcopytab.Rows.Count-2; i++)
                  {
                       currentRow = accountcopytab.Rows[i];
                       if (currentRow["Credit"].ToString().Length &gt; 0)
                      {    
                          Creditvalue = Convert.ToDecimal(currentRow["Credit"]);
                           -------------
                           --------------``
                      }
                }
</code></pre>
