format cells to whole numbers
can you help me right away plz
|
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 |
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