D
I don't recommend that you convert to text. That can come back to haunt you when you have forgotten how you accomplished this. You can use conditional formatting to set the decimal places base on a cell evaluation formula. See the Cond Format Example.jpg for better explanation. Good Luck! 

Attachments
-
254.3 KB Views: 221
, the single data point part, INT((LOG10(100/MEDIAN(DATA))+1))*(MEDIAN(DATA)<100), take for granted that the order of magnitude of the data point set it all, but it's a faulty way to see, because you can have data points that changes between 1000 and 1000.05, the order of magnitude of 1000 may tell you not to use decimals but because you are using a range, the order must comply to show the variation.