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
|