View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
prana1 prana1 is offline
external usenet poster
 
Posts: 14
Default formatting cells

Thanks for all the help!! I got one for ya:

How can I format cells so they have at most 2 decimals places? So, if it is
a whole number, it will not add .00 at the end:

So,
4.14 = 4.14,
2 = 2, not 2.00

Thanks all you guys!