View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Prevent rounding up and down

Hi Terry,

Am Tue, 15 Nov 2016 14:52:11 +0000 schrieb TerrySmith33:

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?


try a custom number format:
[<=0.004]1%;[=0.995]99%;0%


Regards
Claus B.
--
Windows10
Office 2016