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
|