Fixied Decimals with CONCATENATE

Hello Again,

Same spreadsheet as yesterday's question. I'm converting metric to British values and have no problem with fixing the decimals when displaying the number. However, I'm wanting to CONCATENATE the unit of measure to the conversion and end up with 12 places beyond the decimal.
Entered formula is:
=CONCATENATE(CONVERT(T5,"cm","in")," in")
Results in 159.055118110236 in

But = CONVERT(T5,"cm","in")
Results in 159.1 which is what I want.

Any ideas?

Try this:

Please Login or Register  to view this content.

I hope this helps!

Try incorporating perhaps the Round function to round to 1 decimal...

=CONCATENATE(ROUND(CONVERT(T5,"cm","in"),1)," in")