except the final format I am after requires the 5.28" to be fractional such as:

1' - 5 1/4"

Is there a formula for this format?

below is the link to the previous Q and A which I found but I cant seem to augment the formula correctly. Much thanks.

http://www.mrexcel.com/forum/showthread.php?t=72114