Thread: convert meters to feet/inches
View Single Post
  #29   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default convert meters to feet/inches
Hi,

Am Mon, 9 Dec 2019 13:06:52 -0800 (PST) schrieb :

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
Reply With QuoteReply With Quote