View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Irene Lim Irene Lim is offline
external usenet poster
 
Posts: 2
Default 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