| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Force display to round down
Use the function RoundDown
=ROUNDDOWN(A1,0) -- If this post helps click Yes --------------- Jacob Skaria "chuckm" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Force display to round down
On Wed, 1 Apr 2009 10:42:37 -0700 (PDT), chuckm wrote:
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 I do not believe that is possible. --ron |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Force display to round down
On Wed, 1 Apr 2009 10:53:03 -0700, Jacob Skaria
wrote: Use the function RoundDown =ROUNDDOWN(A1,0) -- If this post helps click Yes --------------- Jacob Skaria Of course, that would change the value in the cell. --ron |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Force display to round down
On Apr 1, 2:08 pm, Ron Rosenfeld wrote:
On Wed, 1 Apr 2009 10:53:03 -0700, Jacob Skaria wrote: Use the function RoundDown =ROUNDDOWN(A1,0) -- If this post helps click Yes --------------- Jacob Skaria Of course, that would change the value in the cell. --ron Thanks Ron, I had experimented with FLOOR and various ROUND functions...but as you point out, it changes the value -chuck |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Force display to round down
On Wed, 01 Apr 2009 13:55:14 -0400, Ron Rosenfeld
wrote: On Wed, 1 Apr 2009 10:42:37 -0700 (PDT), chuckm wrote: 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 I do not believe that is possible. --ron If you could store the value in one cell, and display it in another, then the display cell could use the Floor or Rounddown function, as appropriate. --ron |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Force display to round down
Only thing I can think of involves adding a helper cell that rounds down. The
original cell could even be hidden. Lou "Ron Rosenfeld" wrote: On Wed, 01 Apr 2009 13:55:14 -0400, Ron Rosenfeld wrote: On Wed, 1 Apr 2009 10:42:37 -0700 (PDT), chuckm wrote: 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 I do not believe that is possible. --ron If you could store the value in one cell, and display it in another, then the display cell could use the Floor or Rounddown function, as appropriate. --ron |
| Reply |
| 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 | |||
Linear Mode
