ThanksHers another way
Custom format your cellCode:=DOLLARFR(A1,16)
This will convert 2.5 to 2.08 and display it asCode:# "lb".00 "oz"
2.8 would beCode:2 lb. 08 oz
Analysis ToolPak required prior to Excel 2007Code:2 lb. 13 oz
lenze