thanks. That does it very nicely

"Bob Phillips" wrote:

Use a format of

[=1000]#,##0;[=100]#,##0.00;#,##0.0000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"widman" wrote in message
...
Is there a way to format a cell to vary the decimals displayed based on
the
results it is showing?
Ex: if the value is <100 show 4 decimal places, if it is over 100 but
less than 1000, show 2 decimals, and over 1000 show no decimals.