I have a group field that is called event year which takes the year portion out of a date. When I run the report, this four digit number looks like 2,007.00. I want this to read 2007 or 2008...just no comma or decimal places. To do this, in the group expert, I have selected to use the following formula as the group name:

totext({@eventyear},0000)

This formula has gotten rid of the decimal places, but still reads 2,007 or 2,008. Does anyone know how to modify this so that the comma goes away too? Please advise.