In my sample file I had two fields in the data area, and right-clicked
on the heading for one of those fields, e.g. Sum of Units.

If you only have one field in the data area, you could right-click on
the Data field button, or select the specific cells that you want to
format. If you select cells, you may lose the formatting if the pivot
table is changed or refreshed.

GSpline wrote:
Debra,
Your post sounds exactly like what I am looking for. Thanks. I am a little
confused though. When I right-click on the column heading and choose Field
Settings, a window opens that is named PivotTable Field. I must be missing
something because I do not see the Number button. The window contains a Name
field (column name), 3 radio buttons under Subtotals (Automatic, Custom,
Nome), a list box with Sum, Count, Average, Max, Min, Product, Count Nums,
StdDev, stdDevp, Var and Varp, a check box at the bottom left labeled Show
Items With No Data, and buttons on the right labeled Ok, Cancel, Hide,
Advanced, and Layout (grayed out). I tried clicking on various options, the
advanced button etc, but I have not been able to find the Number button.
What am I doing wrong, or what am I missing?

Thanks

"Debra Dalgleish" wrote:


To replace the 1s with "Test":
Right-click on the column heading, and choose Field Settings
Click the Number button, and select the Custom category.
In the text box, type: [=1]"Test";General
Click OK, click OK

GSpline wrote:

Is it possible to change data field values (i.e. if they all show as "1") to
something else on a per column basis? I have 3 different columns, and did
not put any data in the data field so that I can see when the row & column
data match but I need the 1's that appear for matches to be replaced with a
different word per column. Any ideas?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html