I am trying to set up a custom number format. I need it to be able to show
one decimal place, but only if there is a decimal in the data I enter. I
would use the standard format except that I want to have "lbs" after the
figure.

I've used "# 'lbs'" and "#.# 'lbs'" but they don't give me what I want. The
first will round off data with a decimal, and the second will place a decimal
after the number even if there is no decimal in the data entered. I need a
single format that when "75" and "87.5" are entered, it will yeild "75 lbs"
and "87.5 lbs" respectively.