View Single Post
  #1   Report Post  
TerrySmith33 TerrySmith33 is offline
Junior Member
 
Posts: 1
Default Prevent rounding up and down

Hi

I have a table of data which has a series of percentages. The client wants these % displayed to 0 decimal places. However, Excel rounds anything 99.5% and above to 100% and 0.4% and below to 0%.

Is there any way of displaying those as 99% and 1% without affecting the rest of the data or changing the decimal places?

Thanks
Terry