I have a similiar question. My date is in the format of 69 1/8 as a fractional number format. I want to convert it to 4 lb 5 1/8 oz in a single cell but the conversion process can take place in multiple cells, I just want the final "4 lb 5 1/8 oz" as a single cell. I can accomplish this mostly but I end up with 4 lb 5.125 oz and I want the fraction. Any advice.

Thanks

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com