Convert feet/inches to decimal
OK, this can probably be broken down. Unfortunately, I don't have the time
to figure it all out so I'll give you the formulas I'd use
SEARCH, MID, LEFT, RIGHT, CONCATENATE (or you could use A1&A2) and maybe
VALUE.
"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
|