Skip to Content
0
Nov 13, 2012 at 09:11 PM

Currency Amount In Words

455 Views

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