I need to create a cell that will read as a number but display text as well,
but Excel only allows you to customize a cell with one type of text. I am
trying to create a time card where the entry could be 8P or 8H or 8F or even
2P. I then want to add up the columns showing the total P's, H's, and F's
separately. Is there a way to do this?