LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table formating BK523 Excel Worksheet Functions 2 March 25th 09 08:46 PM
Pivot table formating Soccer boy[_2_] Excel Discussion (Misc queries) 1 February 24th 09 05:49 PM
need help with pivot table formating magickarle Excel Discussion (Misc queries) 1 June 1st 07 03:02 PM
pivot table formating lee Excel Discussion (Misc queries) 1 April 27th 07 01:51 AM
How do I get word wrap format to remain in an Excel pivot table? KSchmidt Excel Discussion (Misc queries) 3 October 12th 06 10:39 PM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"