Thread: change feet and inches to decimal inches
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian 1 Brian 1 is offline
external usenet poster
  
Posts: 1
Default change feet and inches to decimal inches
I have feet and inches in a cell as text and want it to be inches as a decimal.
Before (2"-4 1/2") after (28.5)
I would like to us a formula or number type to convert.
Reply With QuoteReply With Quote