Forum Discussion
jdogg29
Mar 16, 2023Brass Contributor
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...
HansVogelaar
Mar 17, 2023MVP
It's not possible. Use one column for the numbers and another column for the text values.
jdogg29
Mar 17, 2023Brass Contributor
great thanks for that. I told my coworker this but he said there must be a way....