Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent user from deleting a tab prevent running macro from menu | Excel Programming | |||
Prevent EXCEL from rounding the result of a calculation | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
prevent rounding up | Excel Programming | |||
HOW TO PREVENT NUMBERS IN SPREAD SHEET FROM ROUNDING | New Users to Excel |