Feet and Inches

[M-dub]

I need to figure out how to create a custom number format
that will convert decimal numbers to feet and inches.
For Example:

12.375 = 12'-4 1/2"

#'-#\" works, but only for the format...or appearance.
I can't figure out what to do with the math...?
Any ideas?
Thanks a lot!

 

[Frank Kabel]

Hi
not sure if this helps but see:
http://www.cpearson.com/excel/fractional.htm

 

[Guest]

Thanks Frank,
It's a start...I don't know if I'm going to be able to
find a definite answer...
Thanks again, though...