Convert amount to text 2

[suburbanites]

Hi,

I am using Crystal XI SP1.

I am using the formula totext() to convert the amount 5,696.12 and it works for the 5,696 part. The text is missing the cents. I would like it to read as five thousand six hundred ninety six and 12/100.

Thanks in advance for your help.

 

[lbass]

Do you mean you are using towords()?

-LB

 

[suburbanites]

sorry. yes, towords()

 

[suburbanites]

It's a database amount field. I am try to write a check

 

[kskid]

How about

ToWords({Table.field},2)

 

[lbass]

It should work just with:

towords({table.field})

...unless maybe you have set your file->options->fields to no decimals.

-LB

 

[suburbanites]

the fields are not set to no decimals. it is set to x,xxx.xx

Somehow the towords() is coming back with "five thousand and six hundred ninety six" only. i would like it to read as "five thousand six hundred ninety six and 12/100

 

[lbass]

Did you check both in the file->options->fields screen as well as the format field->number screen?

-LB

 

[suburbanites]

sorry LBass. it was set to no decimal. Thanks so much. Now it's working.