You can change the number format at a different level from the row/column values.
To do this:
1) right-click your Grand Total value and choose Format...
2) In Grand-Totals change the drop-down for Numbers: to Currency.
3) The Default section will change your number format for columns/rows while the Grand Totals will change it only for the Grand Total value.