Numeric formatting: decimals and no decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Similar Threads

Access stripping decimal places in query 1
How to retrieve number of visible digits after decimal point in VBA 5
formula for decimal point 4
number format? 4
Split a decimal number 3
Open file and set numbers of decimal points 5
Formatting Decimal Places 3
Return amount with various number of decimals 3

Back
Top