| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells to whole numbers
can you help me right away plz
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average only cells that contain numbers | Excel Worksheet Functions | |||
| Format cells to display ordinal numbers ex 21st | Excel Worksheet Functions | |||
| Why will my cells not format? | New Users to Excel | |||
| Hightlighting Numbers & then all Cells to the right of these Numbers. | Excel Worksheet Functions | |||
| How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
Linear Mode
