Labeling Cells with Text but cell value is a number

Say that I need cell C9 to be shown to spreadsheet users as "TPT-2" but I need the value of the cell to be a numerical value so that I can use C9 in a formula.
How do I do this?

Thanks!