Decimal Formating

[#1]

I have a column of data that is formated as a percentage but I want the decimal places to the left to format dynamically. Meaning, if the number is 5.234% then three decimals to the right will show, however, if the number is 5.5% then I only want one decimal to the right to show. The "Number" tab only allows me to set a fixed number of decimals to the right.

Thanks,

Stephen

[johnw]

Hmmm, weird that it isn't directly supported.  This would probably work when using "expression default" as your numeric format.

dual(100*sum(A)/sum(B)&'%',sum(A)/sum(B))

[nagaiank]

If no standard is followed for display of numbers, will it be acceptable if you end up in numbers like those listed below?

3.33333333333333%

12345678.9012345%

1234567890123.45%