| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
display/not display numbers to right of decimal
I have a formula in a cell producing results: e.g. - 40.00 e.g. - 40.25 If the result is an integer, I want it displayed as "40", not "40.00". Hence, I would like to display: 40 40.25 Is there an easy way to do this, either through formatting the cell, or a formula tweak? Thanks. - jim -- James C ------------------------------------------------------------------------ James C's Profile: http://www.excelforum.com/member.php...o&userid=12114 View this thread: http://www.excelforum.com/showthread...hreadid=475988 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions | |||
| Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
| How to remove page numbers from the display? | Excel Discussion (Misc queries) | |||
| sorting numbers more than one decimal | Excel Worksheet Functions | |||
| column headings display as numbers | Setting up and Configuration of Excel | |||
Threaded Mode
