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