Force display to round down

  • Thread starter Thread starter chuckm
  • Start date Start date
C

chuckm

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
 
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
Click to expand...

I do not believe that is possible.
--ron
 
Of course, that would change the value in the cell.
--ron
Click to expand...

Thanks Ron,
I had experimented with FLOOR and various ROUND functions...but as you
point out, it changes the value
-chuck
 
I do not believe that is possible.
--ron
Click to expand...

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
 
Only thing I can think of involves adding a helper cell that rounds down. The
original cell could even be hidden.
Lou
 
Back
Top