>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
And without leading zeros
myvar = [000003754]
? VAL(TRANSFORM(myvar,[@R #######.##]))
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst