Sorry. You guys are SO close. The format is that used in the truss program we
use from MiTek Industries. Their expanation:
"Understanding the MiTek F-I-S Rules
Dimensions are entered in dialog boxes using feet, inches, and sixteenths,
or in decimal feet without any special characters such as dashes or commas.
280308
28 03 08
Feet inches sixteenths

28 feet
3 inches
8/16th's
Examples:
360000 = means 36 ft, 00 inches, 00 sixteenths
250408 is 25-4-8
400 is four inches (0-4-0)
3 is three sixteenths
7267 would be 72 inches and 67 sixteenths

A span of twenty-eight and one-half feet would be entered as: 280600 or 28.5
A three and a half inch bearing is 308
A two-foot overhang is either 20000, 2400 or 2.0
A quarter inch butt cut is 4 (NOT .25 - .25 would be 3 inches)
A six-inch bearing width could be 600"

I hope this helps. You guys are so close. Ron Coderre's suggestion is
dead-on except when the sixteenths exceed 9. (Formula ignores the "1" in 10)
Otherwise it's perfect. Your suggestion is works if there are exactly 6
digits.

Thanks,
Trussman

"Bernard Liengme" wrote:

Your example 120608 suggest you used two digits for inches.
What would 2 ft 0 inch and 5 sixteenths be coded as? 205 ?
We need to know as much as possible about the way data is entered if we are
to be of any help
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Trussman" wrote in message
...
Roger, thanks so much for responding. I tried the formula, but 10907
yields
10 feet, 90 inches, 7 sixteenths, instead of 1 ft, 9 in, 7 sxt. The real
trouble, though, remains that the result isn't a decimal format to be used
in
another formula. ie. adding two lengths together, or calculating a pitch.

"Roger Govier" wrote:
Provided you always use double digits for each measurement (and assuming
lengths don't exceed 99 feet) then

=TEXT(LEFT(A1,2),"#0")&" feet "
&TEXT(MID(A1,3,2),"#0")&" inches "
&TEXT(RIGHT(A1,2),"#0")&" sixteenths"
Regards

Roger Govier