concatenate string and numeric value in Crystal Reports

Jun 5 2012 2:27 PM
I have concatenate the city and pin-code in crystal report like this {studentdetails.city} & ":" & {studentdetails.pincode},but the problem is that the output comes like this Mumbai:4,000,060.00
 
Its giving me wrong answer, the numeric value comes like money value "4,000,060.00"
I wants the answer like this Mumbai:4000060
 
so how can be solved this problem ?

Answers (1)