View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default =CONVERT(A2,"in","ft")

=6/12. Six inches is .5 feet, etc.

Dave
--
Brevity is the soul of wit.


"cybergardener" wrote:

How can I convert inches to feet, I have tried =CONVERT(A2,"in","ft")
--
Thanks
Cyber Gardener