ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Prevent rounding up and down (https://www.excelbanter.com/excel-worksheet-functions/452728-prevent-rounding-up-down.html)

TerrySmith33

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

GS[_6_]

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


Set the NumberFormat to zero decimal places, perhaps!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Claus Busch

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


All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com