On Fri, 4 Nov 2005 14:19:08 -0800, "Sloth"
wrote:

I want a format that will show "35.4" as "35.4 lb/ft" and "35" as "35 lb/ft".
The trick being the decimal is not shown for the second number.

I currently use two different versions depending on the number, but I would
like this to be automaticly done in the format.


Format/Cells/Number/Custom Type: General" lb/ft"

However, if the 35.4 is really a calculated number with more precision, you
will have to round it to 1 decimal place within your formula in order to assure
that only one decimal will be displayed.


--ron