<div>
Try the Round function in SQL<br />
<br />
<a href="http://www.w3schools.com/sql/sql_func_round.asp" rel="ugc">http://www.w3schools.com/sql/sql_func_round.asp</a>
</div>


Try the Round function in SQL

http://www.w3schools.com/sql/sql_func_round.asp [http://www.w3schools.com/sql/sql_func_round.asp]

<div>
Hi Thanks but it does not omit the zeros. I would try the Format function -Do you know how I can specify the format string?
</div>


Hi Thanks but it does not omit the zeros. I would try the Format function -Do you know how I can specify the format string?

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have an unbound datagrid view, I need to format data from 0.07620000000000000 to 6 digits after decimal. Can that be done by code? my SQL is :<br />
&quot;SELECT TOLP, TOLM,0 AS SEQ, KKD*25.4/1000 AS REQ ,TOLP*25.4/1000 AS PTOL, &quot;_ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&amp; &quot;&nbsp; ,KNO, 0 AS MEASURED FROM BPCSELTF.KDHE&quot;
</div>
</div>


Hi Experts,
I have an unbound datagrid view, I need to format data from 0.07620000000000000 to 6 digits after decimal. Can that be done by code? my SQL is :
"SELECT TOLP, TOLM,0 AS SEQ, KKD*25.4/1000 AS REQ ,TOLP*25.4/1000 AS PTOL, "_            & "  ,KNO, 0 AS MEASURED FROM BPCSELTF.KDHE"

Format Unbound DataGridView

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,