Number field is exported as text in excel file after export`

[santhosh_k_n]

Hi All,

I am using a pivot table in one of my doc and in dimensions one of the dimension is calculated dimension which is in number format

On exporting to excel, values of the calculated column is presented as text and options it pop outs as follows

Please help on this

[#2]

Hi

Please try the

Num()

Function for the field

thanks

michael

[nirav_bhimani]

Its just bcoz of its taking that as expression Default.

Go to Property

-Number Tab

- Select Integer

- Apply ok

Then try to export.

Regards,

Nirav Bhimani

[santhosh_k_n]

Hi Michael,

The dimensions are defined using num() fun, but still it displays as text

[its_anandrjs]

Hi,

Go to properties -> Number -> select dimension or expression -> then select Number and in -> Format pattern type ###########

Hope this helps

Thanks & Regards

[santhosh_k_n]

Hi Anand and Nirav,

The dimensions wont be visible in number tab and i am having a numeric calculated dimension

[nirav_bhimani]

Hi,

Can you please share your file with small dataset.

Regards,

Nirav Bhimani

[Anonymous]

Also - (just to make sure)....

Go to User Preferences / Export.

In this tab there are options regarding Default Export Options.

[santhosh_k_n]

Hi

i am adding a dummy report of similar kind

on exporting the chart the num values are presented as text

[santhosh_k_n]

Hi Hamish,

i just gone through user preferences but no change