Hello all,

I currently have an attendance tracker where a user form inputs the attendance into an excel table.
For speed there is a "Reason" comment box where the reason has been abbreviated into a number code.
The list looks like this.
1 HOL
2 HOL-AM
3 HOL-PM
4 SICK
5 SICK-AM
6 SICK-PM
7 UNPAID
8 B HOL

The issue i am having is when converting these numbers to text in a pivot table I can only seem to convert two.
In the values part of the PivotTable Fields I have changed the number format to custom and added this in 
[=1]"Hol";[=2]"Hol-Am"
however when i try to expand this further for the other 6 in my list it does not work.

I am using a pivot table to use the slicer to filter out the months quickly on the attendance report. I am trying to avoid using vlookups hence why I have decided to approach it this way.

Any suggestions on how to expand this to include all 8 on the list?

Thank you