Hi,
Am Mon, 9 Dec 2019 13:06:52 -0800 (PST) schrieb
dizon_albert@yahoo.com:
hello,I tried the formula and it works great, but what if I need to show the fraction also, like (18feet8inches1/8fraction)
try:
=INT(CONVERT(A1,"m","ft"))&" feet "&TEXT(MOD(CONVERT(A1,"m","ft"),1)*12,"# ?/?")&" inches"
Regards
Claus B.
--
Windows10
Office 2016
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)