| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
integer
how do you display numaric data in integer format
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
integer
Format cell/ number/ 0 decimal places, if you want the number to stay the
same but be displayed as an integer. If you want to change the number to an integer, you have a choice, including: =INT(A1) =ROUND(A1,0) =ROUNDUP(A1,0) =ROUNDDOWN(A1,0) or (with some caveats): =FLOOR(A1,1) =CEILING(A1,1) -- David Biddulph "integer format" <integer wrote in message ... how do you display numaric data in integer format |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Text to Integer | Excel Discussion (Misc queries) | |||
| help with rounding up to whole integer | Excel Discussion (Misc queries) | |||
| how do I test for Integer? | Excel Worksheet Functions | |||
| Rounding to nearest integer | Excel Worksheet Functions | |||
| positive integer? | Excel Discussion (Misc queries) | |||
Linear Mode
