Hi Dan, Thank you for your reply. I had tried that but it didn't work. My Co-worker was able to get a work around, keeping this a text column, to put in the commas and the $. Here is what we did if anyone else is interested. She also went a step further and had it insert "No Info" for only MN states...

Hi Justin, Thanks for the response. This is better, I wonder if I change the Value Format back to: valueformat=customNumberAsCurrencyStringRounded Is there is anything different I can do with my Value Expression to insert my Text "N/A" into a numeric field? Thank you Jodie Otten Dominium Inc.

I am trying to customize a numeric column to display "N/A" when the value is blank. For this to happen I needed to switch my value format to HTML. Now that it is HTML the numeric values in the file no longer show up at $1,234 but at 1234. Can I embed formatting into my Value Expression? Here is what...