View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default convert meters to feet/inches

On Mon, 15 Feb 2010 10:06:02 -0800, matt
wrote:

One problem that I have while doing this is that I'd like the results to be
more precise.

I would like 12.35 meters to come out as 40' 6.25"

I'd even like to have the ' and " instead of feet/inches. Is all that a
possibility?

Thanks for help.


=INT(CONVERT(A1,"m","ft"))&"' " &
ROUND(MOD(CONVERT(A1,"m","in"),12)*4,0)/4 & """"

--ron