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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trying to format a number inside a formula 1

Status
Not open for further replies.

WMlodestar

Programmer
Feb 28, 2003
7
0
0
US
I have a Parameter that I am using in a formula. My problem is that I cannot seem to lose the decimal point on the value. The formula returns a new string that contains the totext(parameter), but it has the decimal point there. I'll keep looking.

Appreciate any help,

Wes
 
You can set the formatting in the totext. For instance totext({table.number},"#") returns the number with no commas or decimals. Check your help under totext to find the format that make sense to you.

Lisa
 
Thanks Lisa,
I am new to CR, disclaimer ... disclaimer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top