delete leading zeros

[kcsilentbob]

hello everyone
Running on Crystal XI

I am pulling in a field that returns data like:

"0000012355"
"0001234567"

I have used the CDbl({field}) to cut the zero's out, but now I need to change this to a currency. I need the above field to read:
"123.55"
"12345.67"

Please help!

 

[lbass]

Try:

$(cdbl({table.string})/100)

-LB