Hi

Can anyone tell me how I do the following ?

I am using crystal reports XI release 2

I am trying to take a number and show it as the text version. For example

$150.00 to show as One Hundred and Fifty and 00/100
or
$200.50 to show as Two Hundred and 50/100

Is this possible?

Thank you

Brou

I am sure it is possible with a formula, but it would have to consider a lot of possiblilities and hopefully the data is limited (i.e., nothing over $1000 and nothing negative).  Basically the number would have to broken down by hundreds, tens, ones and cents.  Put through a series of if statements or a switch statement (for each group - hundreds, tens, etc.) to get a string and then combine the seperate strings back to one string.