Numeric formatting: decimals and no decimals

[ppsa]

Hi,

Can anyone please tell me how to format numbers so that if there is no
decimal value a whole number without decimals shows up, but if there is a
decimal value then a number with 1 or 2 decimal values show up? Like this:

1
0
0.2
2.3

Thank you.

 

[Jim Thomlinson]

Have you tried formating as general?

 

[ppsa]

Yeah, it almost does the trick, but I'd like to get rid of the zero to the
left of the decimal (my example below mistakenly includes the zero).

 

[Jim Thomlinson]

Try
Tools -> Options -> View -> Uncheck Zero Values

 

[Steve Dalton]

How about conditional formatting?

Try
Tools -> Options -> View -> Uncheck Zero Values