Formula fields in crystal report.

[nghiemTran]

table.string contain of 00012345 and 12345-ABC
to use lbass's code the following:
if isnumeric({table.string}) then
totext(tonumber({table.string}),0) else
{table.string}
The results showing 12,345 and 12345-ABC.
How to format not to show the comma on the result
of 12,345.
I would like to see 12345 and 12345-ABC.
Please help, really appreciate all your help.

Thanks, Nghiem

 

[lbass]

if isnumeric({table.string}) then
totext(tonumber({table.string}),0[red],""[/red]) else
{table.string}

-LB

 

[nghiemTran]

Thanks LB, it works.