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

No,

2 1/2"
8"
10 1/2"
1'-7 3/8"

These are the different configurations.

Gary

"Biff" wrote:

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