• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. B

    Pivot Table: How to change data format of multiple value fields at once

    Hi Suresh, thanks for you reply. My question is not about simple SUM or Format , but to change "NUMBER FORMAT" for "MULTIPLE VALUE FIELDS" "ALL AT ONCE" In my above example, I have value fields ( columns) 2011, 2012 and 2013 in the pivot table. I want to change the number format of...
  2. B

    Pivot Table: How to change data format of multiple value fields at once

    Good day Bobhc: Many thanks for your quick response. Sorry that I did not explain it clearly. What I am looking for is to change the number format in Pivot Table value field (Field Setting => Number Format) For example: Source table: Region 2011 2012 2013 EU 0,351...
  3. B

    Pivot Table: How to change data format of multiple value fields at once

    Is it possible to change data format of multiple value fields at once (e.g from USD to EUR?
Back
Top