Hi,
Using Crystal Reports 2008, and want to convert $202.00 to "Two Hundred Two and 00/100 Dollars"
When I try:
ToWords({CheckSum}), I get "two hundred two and xx/100 Dollars"
REPLACE(ToWords({CheckSum}), "xx/", "00/"), I still get "two hundred two and xx/100 Dollars" and xx does not convert to zeros.
PROPER(ToWords({CheckSum})), I get "Two Hundred Two And Xx/100 Dollars"
How do I get the format I want?
Thanks,
Ajay Audich