Thank you for the response.
I'm not very familiar with Javascript so maybe you can help me out a little further.
There is already a script in place to format the column:
var acctbal = FormatNumber("#,###.00",Field("ACCTBAL"))
return "$"+acctbal;
How can I add add the two scripts together?