>Try format

>@R #######.##
>

>>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


Thanks, that worked. Now what about for dates that are characters. my date comes in as 05232007 where it is MMDDYYYY. I went into the report expression and applied following format

@D MMDDYYYY

but the date comes out as 05/02/00. I also tried ctod(PROCESSDATE)in the expression but that didn't work either.

thanks
Nick