Outdated Formula

[khan82]

Morning,

The formula below doesn' work any more after i updated my crystal report.
stripstring (left(totext({PAYMENT.Check_Number}),instr (totext({PAYMENT.Check_Number}),".")-1),",")

i updated it with the following formula but i am getting a "," between the cheque numbers...i would only like to display 1234 instead of 1,234

Replace(totext({PAYMENT.Check_Number}),".","")

please advise as to how i can fix it...i know its there in plane sight but my brains not really functioning well today...

Cheers

 

[Charliy]

Replace(totext({PAYMENT.Check_Number},"######"),".","")

 

[khan82]

Thx!