Hi Everyone,

Essentially my goal is to create a pivot table with values(numbers), and have them displayed as text.
ie
Number Codes
1 FIP
2 FOP
3 FNP
4 DIP
5 DIO
6 DOI
7 DNP
8 DIA
9 FI-
10 DOA
11 DNA
12 DOP
13 DAO
14 DNO

I learnt today that custom number formats have a limit of two conditions, so [=1]"FIP";[=2]"FOP";[=3]"FNP";[=4]"DIP";[=5]"DIO";[=6]"DOI";[=7]"DNP";[=8]"DIA";[=9]"FI-";[=10]"DOA";[=11]"DNA";[=12]"DOP";[=13]"DAO";[=14]"DNO";General wont work.

However I am unsure why if I have 7 conditional formats

Cond. Format 1
Rule - Format only cells that contain cell value 1,2
Custom Format - [=1]"FIP";[=2]"FOP";General

Cond. Format 2
Rule - Format only cells that contain cell value 3,4
Custom Format - [=3]"FNP";[=4]"DIP"

etc

it still will not work.

Would someone mind shedding some light, or does anyone have another work around for displaying text values in a Pivot Table as opposed to numbers.

Thanks heaps