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!

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

--
Regards
Frank Kabel
Frankfurt, Germany

"M-dub" schrieb im Newsbeitrag
...
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!

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...