If one cell, click in it, go to Format/cells/Number and select Number from
the list. Then, pick 1 for decimal places.

In the cell, I assume it has a formula. Let's say the formula is:

=a2/a3

instead, enter =IF(A2/A3=0,"",a2/a3)



"Milwpacker" wrote:

I want to delete the percentage sign (%) in a cell that is formulated for
mpg's. How do i do that so it shows MPG or nothing at all and still has a
one decimal point answer such as 24.5 ??