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!

Remove Comma, show decimals 1

Status
Not open for further replies.
Jun 11, 2008
34
US
I have the following formula
totext(Sum ({@giftamt}, {gifts.giftacctno}),0,"") It returns a number similar to this: $8720. Thus I successfully removed the comma. However I want to remove the dollar sign and add two decimals at the end. Thus $8720 becomes 8720.00. How would I accomplish this?
 
totext(tonumber(Sum({@giftamt},{gifts.giftacctno})),2,"")

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top