formatting cells

P

prana1

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!
 
D

David Biddulph

I can't think of a way of doing it purely by formatting, but you could use
=ROUND(A1,2) and format as General.

That would round 4.142 to 4.14 and display it as 4.14, but it would leave 2
as 2 and display it that way.
 
Top