Get PivotPal: http://www.excelcampus.com/pivotpal
PivotPal Help: http://www.excelcampus.com/pivotpal-help

PivotPal automatically formats the numbers when a field is added to the values area. It detects the formatting of the cells in the source data for the field, then applies that same formatting to the pivot table. You can quickly change the formatting by selecting from any of the predefined formats in the formats drop-down.

You can modify this list by click the My Number Formats button on the XL Campus tab. The My Number Formats window also has an option to import any of your custom formats into the active workbook. This can be used even if your workbook does not contain pivot tables.