View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sammy sammy is offline
external usenet poster
 
Posts: 48
Default Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56)

Hi All,
Is there anyway to convert an architectural units text with feet, inches and
fractions of an inch, like (5'-6 3/4") to feet and decimals of a foot, like
(5.56)?
TIA,
Sal