View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chuckm chuckm is offline
external usenet poster
 
Posts: 15
Default 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