I’m wondering how I can keep the formatting of a number value when using it within a text string. i.e., when I add a number of cells, and get a value, I want the say “not more than 50.1%” where 100 is the sum of the cells. When I try this, I lose the formatting, and the value of the text cell is “not more than .5008961”. Does anyone know of a way to keep the formatting?
