Concatenate function with numerical cells

[JoeTank]

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

 

[MintJulep]

Excel stores numeric values as floating-point numbers.

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:

="use "&TEXT(A1,"# ?/?")&" plate."