Pivot table export to excel

[jordan231]

Dears, I have a pivot table with number of dimmension fields. When i export numeric data into excel they turn into text format. Expresions keep the proper format. I tried to use round and num functions without success also seetings in sheet properties are correct. Does anyone has any idea ? Thanks for any hints.

[ashfaq_haseeb]

Hi,

Right click on pivot table --> Properties --> Number --> Select your Expression --> and select numbers

Regards

ASHFAQ

[jordan231]

In pivot properties you can only change settings for Expressions i'm trying to handle Dimmension settings.

[ashfaq_haseeb]

Attach sample qvw with data please and scenerio

Regards

ASHFAQ