With a helper column this gets close to your needs
=ROUND(A1,5-LOG(A1))
but it show 1 decimal when A1 1000
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"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.