Straight table dimension

[priyarane]

Hi Experts,

I have added one column as dimension in straing table.

Now I want that in number format when I export to excel.

I have changed that in Doc properties-Number, its fine in table box. But when I add as dimension in straight table then its changing it to text when I export.

I want only 2 decimal after " . ".

[#2]

Hi Priya,

You can change that in Number tab.

Regards,

Faisal

[priyarane]

Hi Faisal,

It is Dimension, so Its not in number tab.

[Anonymous]

Hi Priya,

Go to Excel Number format option. Try changing it from General to Number.

Regards,

Nishant

[#5]

The Number tab is valid only for expression.

Add a Calculated Dimension like this:

Num( [your field],'#.##0,00')

on export in excel work for me

Bye

[#6]

Then

edit the dimension and give the following expression

=Num(dimension,'#.00')

regards,

Faisal

[priyarane]

still its changing to Text format after exporting to excel.

[priyarane]

still its changing to Text format after exporting to excel.

[#9]

Follow this instructions and chose which one you like it.

Hope I helped you