Thread
:
convert meters to feet/inches
View Single Post
#
26
Brian Canes
Junior Member
Posts: 4
Use the =CONVERT(B5,"m","ft")
and format the cell as
#" feet" 0/12 "inches"
So if text is required =TEXT(CONVERT(11.87,"m","ft"),"#"" feet"" ?/12 ""inches""")
will yield
38 feet 11/12 inches
Regards
Brian
Reply With Quote
Brian Canes
View Public Profile
Send a private message to Brian Canes
Find all posts by Brian Canes