>How can I format a character field that is displaying numbers to use commas as thousand separators? I'm trying to use TRANSFORM() with a format code of '###,###,###' but am getting commas in the wrong places. Thoughts anyone?

TRANSFORM("123456","@R ###,###,###")

Note the space after the @R.