<p>Hi All,</p>
<p> </p>
<p>I have requirement to define up to 8 decimal and it should be dynamic.</p>
<p>My code is:</p>
<p>a = 189,214,958.4</p>
<p>Format(a,"##,###,##0.00######")</p>
<p>Result :<span style="font-size:14px;">189,214,958.40000001</span></p>
<p><span style="font-size:14px;">Expected Result: </span><span style="font-size:14px;">189,214,958.4</span></p>
<p> </p>
<p><span style="font-size:14px;">Any Idea why there is additional .0</span><span style="font-size:14px;">0000001 in my value?</span></p>
<p> </p>
<p><span style="font-size:14px;">Any other way to format my data?</span></p>
<p> </p>
<p> </p>
<p><span style="font-size:14px;">Cheers,</span></p>
<p><span style="font-size:14px;">Fera</span></p>
