How do I only show decimal places if there are any?

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

Guest

In Excel I only want to show 2 decimal places if the calculation is not a
whole number. If the result is 99.00 in the field I want to show 99, if the
result is 99.75 in the same field I want to show 99.75. Is there a way of
doing this.
I would be grateful for your help
 
But what about 99.75323423523?

the OP could use a formula and a format of General:

=round(existingformula,2)
 
Thanks Dave,
I have widened the field but still have the problem which only occurs when
the number is gets to 100 million: I was testing for maximums & I think it is
unlikely to be a 100 million. I can live with that , although there does seem
to be a problem in my version of Excel-Office 2003 if the value gets to this
level.
 
You have 100,000,000 in a cell and you're seeing ###'s????

Do you have a formula in the cell? What formatting did you use?

I don't think I've ever seen this happen when formatted as General.
 
Back
Top