Try this:

Format the cell as GENERAL

=IF(MOD(A1*B1,1),ROUND(A1*B1,3),A1*B1)

Biff

"Charles Knight" <Charles wrote in message
...
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.