I am creating a report that has a field of 9 character length. I want to display my report with comma and decimal when it prints. I tried setting the format in report express to #######.## but it comes out wrong by dropping the first digit of the decimal part. If I had a character value of

000003754

I want it to show me

37.54

instead it is showing me 

0000037.4

notice how it drop the 5 after the decmial.

how do I format this correctly?

thanks
Nick