<div>
Looks good. &nbsp;If the numbers can be larger than 1000 then you may want to also specify the thousand separator.<br />
<br />
No thousand separator<br />
totext(numberfield,3,'')<br />
<br />
mlmcc
</div>


Looks good.  If the numbers can be larger than 1000 then you may want to also specify the thousand separator.

No thousand separator
totext(numberfield,3,'')

mlmcc

<div>
<div class="content wysiwyg-content">
How do I format a number in a Crystal formula field? &nbsp;The formula I have entered in the field is:<br />
formula = {PurchaseOrderLines.UPMLWI<wbr />DTH} &amp;&nbsp; &quot;''W x &quot;&nbsp;&amp; {PurchaseOrderLines.UPMLLE<wbr />NGTH} &amp;&nbsp;&quot;'L&quot;<br />
<br />
I want to format the field purchaseorderlines.upmlwid<wbr />th and purchaseorderline.upmlleng<wbr />th to show 3 decimals places - (example: &nbsp;2.253). &nbsp;Currently, only 2 decimal places are showing and it is rounding up/down. &nbsp;I am not able to format this field like a normal numeric field in Crystal. &nbsp;On numeric fields, I normally choose format field and choose the number tab and make my selection. &nbsp;In this case, the number tab does not show. &nbsp;<br />
<br />

</div>
</div>


How do I format a number in a Crystal formula field?  The formula I have entered in the field is:
formula = {PurchaseOrderLines.UPMLWIDTH} &  "''W x " & {PurchaseOrderLines.UPMLLENGTH} & "'L"

I want to format the field purchaseorderlines.upmlwidth and purchaseorderline.upmllength to show 3 decimals places - (example:  2.253).  Currently, only 2 decimal places are showing and it is rounding up/down.  I am not able to format this field like a normal numeric field in Crystal.  On numeric fields, I normally choose format field and choose the number tab and make my selection.  In this case, the number tab does not show.  



How do I format a number in a Crystal formula field

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.