I have a formula that I use in my header to display the year.

 

The year is the result of a calculation, and it is working fine, but it wants to display a comma after the first digit (because it thinks it is a number and is applying a thousands separater).

 

the piece of the formula that calculates the year is:

 

totext({glperiod.year}-{?Current Year},0)

 

I'm using the ,0 expression to drop decimals, but I don't know how to drop the comma.

 

Thanks,

 

Paul

 

 

I noticed that it also worked with a double quote, is there a difference in what the single vs. double quote will do?

 

Paul