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