How to display and print a value different from that in cell

[rcavedo]

How does one display and print a value that is different from that in a cell?

For extensive calculation purposes that involve both the column and the row a cell occupies, I have numeric values in all cells. However, in some cells that numeric value actually repersents text. There are only seven different values that represent text. The complication is that for further calucations the values MUST remain numeric.

Is there a way to retain the numeric value in the cell, but display the text it represents?

Thanks

Bob

 

[rcavedo]

The ISNA function was the key to the TOTAL solution!
Thanks,
Bob