Crystal Reports- How to print City,State, Zip in one line?

[ruvi]

Hi,

I am using the following formula to print City, State, and Zip in a single line.

Trim ({tblInvoiceRpt.City})+", "+Trim ({tblInvoiceRpt.State})+" - " +
ToText({tblInvoiceRpt.Zip})


The result I get is -

Moorseville, NC - 45,677.00

The Zip code is displayed with decimal places. How to rectify this? Please help.

Thanks,
Ruvi