Formatting the same column

[Deepika]

Hi,

I have a query item called units.The values are with 4 decimals, however, Can anybody please let me know the units to be displayed in the following manner.

2.456

125

instead of:
2.456

125.000

Thanks in advance.

Deepika

[almeids]

Left horizontal alignment?

[rockytopmark]

If I am not mistaken, just set the Format to Numeric and leave the other settings as Default.  I believe you will see decimals only when there is a non-zero to the right.

[Deepika]

Hi

Thanks for your reply...


Deepika