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