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?
Bookmarks