View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Convert feet/inches to decimal

Is the format ALWAYS the same?

In other words, will there ALWAYS be some feet, some inches and some
fraction of an inch?

Biff

"dingy101" wrote in message
...
Is there a way to convert a value in a cell that is 2'-3 1/2" to a
decimal such as 27.5" ?

excel 2003 SP2

Thanks
Gary