View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] deo.dharwad@gmail.com is offline
external usenet poster
 
Posts: 1
Default convert meters to feet/inches

On Thursday, 5 June 2008 01:39:03 UTC+5:30, Ann wrote:
i'm trying to convert from meters to feet and inches (not just feet or not
just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches for
example not 6.x feet or 78 inches.
here's the formula i have, which i can't get right.
=CONVERT(2,"m","ft""in").
tia

100*100m= howmanyfeets