</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">True DBGrid for WinForms</div> <div id="PageTitle"><div id="PageTitleText">Custom Number Formatting</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="datapresentationtech.html">Data Presentation Techniques</a> > <a href="textformatting.html">Text Formatting</a> > <a href="numericfieldformatti.html">Numeric Field Formatting</a> > Custom Number Formatting</td></tr></table></div> <div id="BodyContent"> <p>You can customize the display of numeric information by setting the <a href="C1.Win.C1TrueDBGrid.4~C1.Win.C1TrueDBGrid.C1DataColumn~NumberFormat.html">NumberFormat</a> property to a custom value rather than to a predefined option.</p> <p>For example to set a numeric column to specifically display with three decimal points, set the <a href="C1.Win.C1TrueDBGrid.4~C1.Win.C1TrueDBGrid.C1DataColumn~NumberFormat.html">NumberFormat</a> property using the following code:</p> <p class="hs-toggler">To write code in Visual Basic</p> <div class="hs-toggler-container" style="DISPLAY: none"> <div class="FilteredContentVB" data-title="VB" data-itemid="VB"> <table class="SyntaxTable"> <tbody> <tr> <th>Visual Basic</th> <th> <div class="CopyCodeWrapper"> <span class="CopyCode">Copy Code</span> </div> </th> </tr> <tr> <td colspan="2"> <pre> Me.C1TrueDBGrid1.Columns("Value").NumberFormat = "0.000" </pre> </td> </tr> </tbody> </table> </div> </div> <p class="hs-toggler">To write code in C#</p> <div class="hs-toggler-container" style="DISPLAY: none"> <div class="FilteredContentCS" data-title="CS" data-itemid="CS"> <table class="SyntaxTable"> <tbody> <tr> <th>C#</th> <th> <div class="CopyCodeWrapper"> <span class="CopyCode">Copy Code</span> </div> </th> </tr> <tr> <td colspan="2"> <pre> this.c1TrueDBGrid1.Columns["Value"].NumberFormat = "0.000"; </pre> </td> </tr> </tbody> </table> </div> </div> <p>To set a date column to specifically display in the mm/dd/yyyy format, set the <a href="C1.Win.C1TrueDBGrid.4~C1.Win.C1TrueDBGrid.C1DataColumn~NumberFormat.html">NumberFormat</a> property using the following code:</p> <p class="hs-toggler">To write code in Visual Basic</p> <div class="hs-toggler-container" style="DISPLAY: none"> <div class="FilteredContentVB" data-title="VB" data-itemid="VB"> <table class="SyntaxTable"> <tbody> <tr> <th>Visual Basic</th> <th> <div class="CopyCodeWrapper"> <span class="CopyCode">Copy Code</span> </div> </th> </tr> <tr> <td colspan="2"> <pre> Me.C1TrueDBGrid1.Columns("BirthDate").NumberFormat = "MM/dd/yyyy" </pre> </td> </tr> </tbody> </table> </div> </div> <p class="hs-toggler">To write code in C#</p> <div class="hs-toggler-container" style="DISPLAY: none"> <div class="FilteredContentCS" data-title="CS" data-itemid="CS"> <table class="SyntaxTable"> <tbody> <tr> <th>C#</th> <th> <div class="CopyCodeWrapper"> <span class="CopyCode">Copy Code</span> </div> </th> </tr> <tr> <td colspan="2"> <pre> this.c1TrueDBGrid1.Columns["BirthDate"].NumberFormat = "MM/dd/yyyy"; </pre> </td> </tr> </tbody> </table> </div> </div> <a name="seealsobookmark"></a> <div class="SectionHeading" id="seealsoSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">See Also</span></div><div id="seealsoSectionContent" class="SectionContent"><div class="SeeAlsoLink"> <a href="inputvalidationwithb.html">Input Validation with Built-In Formatting</a></div> </div> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright © <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a href="http://our.componentone.com/groups/" target="_blank">Product Support Forum</a> | <a href="http://feedback.componentone.com/forums/255782-winforms-documentation" target="_blank">Documentation Feedback</a> </div> </body> </html>