Is there a way to limit the deicmal formatting to only non-whole numbers.
Example: 5 would show as 5 instead of 5.000 while 5.245 would still show
correctly.

The cell I am working with is a calcuted one (=sum(a1*b1)) so the number is
sometimes requires a decimal and sometimes not. Any help or suggestions would
be greatly appreciated.