Converting Metric to Imperial
=CONVERT(D6,"m","ft")
"bj" wrote:
what formula did you use
"Seb" wrote:
I have converted metric into imperial using the convert function which gives
me the result I want, however Excel doesn't write it in this format 11'3"
but rather as 11,3
Is there any way that Excel can show the proper way (11'3") ?
|