Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot 2007. Format row field
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to I show X-Axis field names in Pivot Chart (2007) | Excel Discussion (Misc queries) | |||
Excel 2007 - Pivot Table - field calculation help | Excel Worksheet Functions | |||
Pivot charts filter field in 2007 | Charts and Charting in Excel | |||
How do I insert the same field twice in an Excel 2007 pivot table | Excel Worksheet Functions | |||
Pivot Table Row Field Format (OLAP Source) | Excel Discussion (Misc queries) |