ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to remain formating in Pivot Table? (https://www.excelbanter.com/excel-programming/333525-how-remain-formating-pivot-table.html)

Irene Lim

How to remain formating in Pivot Table?
 
I already set the measure to two decimal places in OLAP but when i drag the
measure to Excel, the Formating for the excel is not correct.
Let say I format the measure manually in excel but when i drag it back to
Field List and drag it again in the Pivot Table, it will remove the previous
formating.
How to make it permanent remain formating recorrectly?
Thanks.
--
Regards,
w@@K


All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com