ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   format cells to whole numbers (https://www.excelbanter.com/excel-discussion-misc-queries/115258-format-cells-whole-numbers.html)

Nikki

format cells to whole numbers
 
can you help me right away plz

Fred Smith

format cells to whole numbers
 
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.

--
Regards,
Fred


"nikki" wrote in message
...
can you help me right away plz




Dave Peterson

format cells to whole numbers
 
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)

nikki wrote:

can you help me right away plz


--

Dave Peterson


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com