View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JimS JimS is offline
external usenet poster
 
Posts: 11
Default Can you eliminate zeroes

I have a table with lots of percentages. One column might look like
this:

25.00
24.81
25.00
21.00
22.45
23.46

I type these in and they are not the results of formulas. Is there a
way to make the numbers that have a 0 or 00 fraction just show up as
the whole number so the table would look like this:

25
24.81
25
21
22.45
23.46

Thanks