Pivot 2007. Format row field

H

Hennie

Hi,

I have a pivot table with one of the fields displaying document numbers. The
field is formatted for numbers in the source and display accordingly,
however, it display as dates in the pivot. I manually changed the format, but
when I want to filter, or refresh, the numbers again show as dates which
makes it impossible to select specific numbers.
Is there anyway to change the format to display only numbers?

Thanks
Hennie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Template with fields and premade texts.. 0
VLOOKUP a Pivot Table Filter 0
Slicers and Calculated Items in Pivot Table 2
Excel pivot table, numbers are reverting to dates format 0
Address Format changed after Migration 0
Value filter in the pivot table is disables 0
Pivot Table Hide Selected Field 2007 0

Top