I've noticed that when formatting a numeric field, it seems that there is a common type missing:

1,234

I need to format a numeric field, including a comma, but omitting the decimal, since I'm only dealing w/ integers.

Does anyone know how to accomplish this?

thanks

try "N0"

thats the letter N and the number 0

--
Ben Sullins
Sql Developer - Our Vacation Store

I had the same issue and found the solution here.

http://msdn.microsoft.com/library/de...rmatnumber.asp

I ended up using

=formatnumber([DATA_FIELD],2,,TriState.True)

good luck