Can you apply a more sophisticated 'rounding' than provided in Inspector? ie. A number <100 I'd want to 1 decimal point, but >100 I'd want rounded to 0 decimal points. A very small number might need 2 decimal points.

I was actually wondering if there was some trick within 'formatting', but yes, your method will work through an autoenter field when I import the data. Thanks.

Not sure how you define 'very small' but here's one way to do it:

Case(

n > 100 ; Round( n ; 0 ) ;

n > 1 ; Round( n ; 1 ) ;

Round( n ; 2 )

)

But this has to be implemented at the data level, it can't be done at the layout level via Inspector's formatting options.