Numeric formatting: decimals and no decimals

P

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.
 
P

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top