3 Replies Latest reply: Nov 13, 2012 12:48 PM by Gysbert Wassenaar RSS

    wrong format in excel

    steve peroni

      Dear all,

      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

      stefan