View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob B[_2_] Rob B[_2_] is offline
external usenet poster
 
Posts: 6
Default Can I turn off roundup automatically for a cell?

Hello,

Does anyone know if there is a way to display 99% in a cell (if that
is the calculated output based on a formula) if I am limiting the
number to 0 decimals and the real output is 99.95%? Currently, it
show 100% if I limit the cell to no decimals. Basically, I would
rather it say 99% and turn off the roundup.

Thanks