Applying formatting to a dimension

The trick is that you have to remember to use a calculated dimension. And then,

=num([Field],'######,###.00')