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!

CRYSTAL REPORT -CONVERT NUMBERS TO WORDS WITH AND WITHOUT DECIMAL PLACES 1

Status
Not open for further replies.

DJSHWEIZ

Systems Engineer
Oct 9, 2019
3
KE
I am converting numbers to words using formula TOWORDS(X). The formula works fine when I have decimal places e.g. 500.59 it reads five hundred and 59/100. This is exactly what I wanted. but when I have numbers without decimal places, for example in 500 am getting five hundred and xx/100. is there a way I can remove xx/100 where I don't have decimal places but get 59/100 format when i have decimal places?
 
Hi DJSHWEIZ

Change your formula to this:

Code:
Replace(ToWords({Table.Field}), 'and xx / 100', '')

Hope this helps.

Cheers
Pete
 
Worked like magic. Thank you so much Pete
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top