Concatenate function with numerical cells
Concatenate function with numerical cells
(OP)
When I usse the concatenate function and include a cell with a numerical value (which is the result of a calculation) the result is a sentence with a number with lots of decimal points. Sometimes I want the numerical value to be formated as a fraction or maybe a value with two decimel points. I can't find a way to have the numerical cell format carry over into the result of the concatenate function. For example, I want "Use 15/16 inch thick plate", not "Use 0.9375 inch thick plate". Any suggestions would be appreciated. Thank you.
Joe Tank





RE: Concatenate function with numerical cells
Cell formatting changes the way that value is displayed. Formatting does not change the value.
Concatenate is a text function. If you feed it a numeric value, it changes the value to a string, and uses that.
You need to be more explicit in building your concatenated string by telling Excel exactly what you want to do.
For example:
CODE