![]() |
pivotal table problem
In pivot table in Row column one of the field has more than 16 digits and any
changes in the page (in pivot) changes row with less than 16 character. In short, I need to change column with format cell. Can I keep the format of cell permanent with some command ? It should not change even with change in page filter. |
pivotal table problem
Right-click on a cell in the pivot table
Choose Table Options Remove the check mark from AutoFormat table Click OK Vijay Kotian wrote: In pivot table in Row column one of the field has more than 16 digits and any changes in the page (in pivot) changes row with less than 16 character. In short, I need to change column with format cell. Can I keep the format of cell permanent with some command ? It should not change even with change in page filter. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 11:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com