Since, my datasource table is a Reporting Summary Table and the columns  are all string and not money data types etc, I am using the onItemDatabound event  to:

convert the money fields to a decimal type
using the  format  string to add   , and decimal formatting
Now with your tip on alignment   - setting the  cell   .horizontalalign = horizontalalign.right

The dataformatstring won’t work on a string money field in the datasource table.