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

Removing decimal points from a currency field 1

Status
Not open for further replies.

CollectionDude

IS-IT--Management
Dec 8, 2003
5
US
I'm having trouble removing the decimal point in a currency field.

350.61 I want to show 35061
350.00 I want to show 35000

I've tried

ToNumber({Payment.Amount},0)
ToText({Payment.Amount},0)

and both remove the cents .61 or .00

Any help would be great!!

Thanks in advance

CD
 
You could use:

{Payment.amount} * 100

-LB
 
WOW!!!

Cant believe it was that simple, that did the trick!!!

Thanks!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top