format cells to whole numbers

F

Fred Smith

Yes, if you tell us what your question.

If you want a number with no decimal places, right click on the cell, choose
Format Cells..., change the number of decimals to zero.
 
D

Dave Peterson

Give the cell a custom format of 0.

The value won't change. But it'll be displayed as a whole number.

If you actually want to change the value, you could use another cell and put a
formula like:
=int(a1)
 
Top