Pivot Table: Reformatting Columns

Hi,

For some reason, Pivot table will not retain the original column's formatting, so you need to do it in the Pivot table anew, which is annoying, but not the main problem.

Here is a description of the problem:

1. You load a number field (Field1) to the Pivot table, formatted it as needed.
2. Take Field1 off the table.
3. Load another number field to the table (Field2), and format it as needed (different from Field1).
4. Re-load Field1 to the table.
5. Problem: Field1 lost it's formatting from step #1, and now has the formatting of Field2.

Any help for this annoying issue is appreciated.

Regards.