I need calculated values to be displayed without any trailing zeros. For
example:
if the result is 12.0, I need it displayed as 12
if the result is 5.50, I need it displayed as 5.5
but... in a worksheet of calculated values, I need the values displayed to
the hundredth's place, as long as there are no trailing zeros, so I can't
just format the cells to one placeholder.

Can this be done? THANX.