Avatar

Level 10

No, you misunderstood me.

The decimal places with an 8 in the pattern will only appear if the value is not 0.

So with num{z99.888} the decimal places will only appear when they are not 0.

When you use the pattern num{zz9.998} the first and second decimal place will be always shown, even with 0 values and only the third is optional. When you enter 2, or 2.0, or 2.00 or 2.000 it will be formatted into 2.00 but when you enter 2.123 it's formatted into 2.123