Thanks Naomi and Sergey,

I ended up using

convert(char(12),convert(money,numericfield),1) as cnumericfield

which has the same effect as

transform(numericfield,'9,999,999.99') as cnumericfield