This content has been marked as final. Show 3 replies
I would know if there is a way to avoid format number conversion in Excel.
I've a pivot like this
Supplier Purchase_2012 Purchase_2011 References
aaaa 12345 456577 C1 -- C2 -- C3
Supplier, Purch_2012 and Purch_2011 are dimensions, Refrences is an expression
When I export to Excel, I need to convert the "Purchase columns" (2012 and 2011) because aren't recognize as number by Excel
How can I define these columns as number avoiding any kind of conversion in Excel ?
Thanks in advance