Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove formatting when using ToText({number})??

Status
Not open for further replies.

ewilkes

IS-IT--Management
Feb 10, 2003
8
US
When converting a number to text, how can I remove the numeric formatting so that it is just numbers? example:
{@AcctNumber} displays as 45789
ToText({@AccountNumber}) displays as 45,789.00. Is there a way to remove the "," and the ".00"?
Thank you
 
Use:
----------------------------------
ToText({@AccountNumber},0,"")
----------------------------------
This indicates no decimal points and no thousands seperator.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top