>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

cValue='000003754'
?ROUND(VAL(cValue)/100,2)