You can use the Format Painter button on the toolbar, to copy the
formatting from the source data, and apply it to the detail sheet.
Do this manually, or record a macro, then run the macro as required.
Gregg Riemer wrote:
When you double-click a cell in the data area or a pivot table, Excel places
the detail data summarized in the cell on a new worksheet.
Unfortunately, the number formatting on the new worksheet doesn't seem to
follow the formatting of the source data. I can use the Format, Style,
Number to make the formatting the same for each numeric field, but I don't
want the same format for each numeric field. For example, I want some of the
columns to be comma with 3 decimal places and others to have no decimal
places just like they are in the source data for the pivot table.
Any suggestions?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html