Force display to round down

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
 
R

Ron Rosenfeld

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
 
C

cmryglot

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
 
R

Ron Rosenfeld

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
 
R

Rookie 1st class

Only thing I can think of involves adding a helper cell that rounds down. The
original cell could even be hidden.
Lou
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top