| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force display to round down
Hi,
Is there a way to force the display format to always round down? If I put a number in a cell...say 15.6, and I set the display format to have zero decimal places, the display is 16 (rounded up) and the cell value is still 15.6. Is there a way to have the displayed format always round this down....so that in this case the display would be 15 and the value would continue to be 15.6? thanks chuck |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get 18 numbers to display in a column and not round out | Charts and Charting in Excel | |||
| Round/Display (HR:MN:SEC) data in decimal HR format for Time C | Excel Discussion (Misc queries) | |||
| Force a cell to display as Text | Excel Programming | |||
| How to force userform to display everything? | Excel Programming | |||
| How? Force Sheet1 to display each time the workbook is opened. | Excel Programming | |||
Threaded Mode
