I need help with a formula. I need to format a column of cells so that if
the number in a cell has a value after the decimal place (e.g.: 6.5), it
displays the value (e.g: 6.5 -- no rounding up or down), BUT if there are
only zeroes after the decimal place (e.g.: 6.0), the decimal and zeros are
removed so that only the integer (e.g: 6) is showing.

The numbers in the column will vary - some will have a value after the
decimal, some will not. They are also added up and used in other formulas.

Any help is appreciated. I've tried to search the formulas but can't see
anything that would work.