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

[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

 

[Anne Troy]

Format the cells as General.
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

 

[Dave Peterson]

But what about 99.75323423523?

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

=round(existingformula,2)

 

[Guest]

I have tried using general but it shows 99.75 as 99.8

 

[Guest]

I have tried using general but it shows 99.75 as 99.8

 

[Dave Peterson]

Widen the column a hair or two.

I have tried using general but it shows 99.75 as 99.8

 

[Guest]

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.

 

[Dave Peterson]

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.