Forum Discussion
Trying to assign a number value to non-numerical value but still display the text not number
I am working on a timesheet and I need the cells to show the text like "Morning, Evening, Night" etc but the cell needs to have a numerical value but still show the text, not the value. The numerical...
Is anyone able to help with this?
It's not possible. Use one column for the numbers and another column for the text values.
- great thanks for that. I told my coworker this but he said there must be a way....
