You can convert the character field to numeric in a Formula.
>My report has a field called Duration which is defined as Character 5.
>So on the report I have Durations such as 5.00, 3.00, but then there are some values such as 05.00 and 03.00. What's the best way to suppress the leading zeroes Crystal Report when you don't have a number and can't use the Customize Number under Format Field. At least I don't think I saw it as an option. Thanks very much!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer