View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default 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