'$'+PARSENAME(CONVERT(varchar,CONVERT(money,sum(yourColumnName)), 1),2) ParseName function got rid of my trailing zero's. the rest explains itself.
A few very basic points about CKEditor today. Let's say you have a typical textarea named foo and you want