crystal reports : truncate leading zeroes (0's)?

Question

In crystal reports, how do you remove leading zeroes?

I realize for the number 0000012313, you can use right(0000012313, 5) and return 12313; however this is presuming this is a fixed length.

any ideas?

thanks in advance

Answer 1

Use the VAL() function.

Answer 2

Use cint(00000123)