Hello,

I am using Crystal Reports XI and I have a string field giving me sales amount (@SalesAmount - this is an invoice/credit memo report). When there in invoice display it will show the invoice amount (no problem here), but when the credit memo is displayed I get a minus sign for example -253.12, what I really want is (253.12) instead. How can I get the parentheses to show I there is no number tab in the format editor. Below is my code.  Thank you in advance.

WhilePrintingRecords;
if PageNumber <> TotalPageCount then
"**********"
else if OnLastRecord OR ({tarPrintInvcHdrWrk.InvcKey} <> Next ({tarPrintInvcHdrWrk.InvcKey}))then
ToText ({@SalesAmount}, {tarPrintInvcHdrWrk.MCDecPlaces} )

do the simple thing...you know it's a number it is just formatted as a string...

write a formula like:
val({table.field})

now you can format it as a number

HTH

Thanks anyway, but there is no number tab. This is a string.