Forum

Notifications
Clear all

Pivot Table: column not keeping format

8 Posts
3 Users
0 Reactions
47 Views
(@Anonymous)
Posts: 0
New Member Guest
 

Hi,

This is the scenario:

  1. I add a number column (ColA) and format it as needed.
  2. I replace ColA with new Number column (ColB) and format it differently from ColA.
  3. I remove ColA.
  4. I re-add ColA. It lost its formatting, and now have either its original formatting, or ColB formatting.

How can I convince Excel to maintain ColA formatting?

Better yet, why Excel doesn't maintain columns' formatting from the original table?

 

Regards,

Ayal.

 
Posted : 10/01/2022 5:37 am
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

Hello,

Don’t delete ColA is a good start to retain the formatting made for that specific column. You will get the same result if you remove other formatted columns and later add new columns bearing same header names. For Excel these table columns you add are new and will format them as per defined table style.

Br,
Anders

 
Posted : 11/01/2022 2:10 am
(@Anonymous)
Posts: 0
New Member Guest
 

Dear Anders,

 

I cannot avoid deleting ColA.

Scenario for example: when analysing data with many columns, you want to put ColA next to ColB on a chart, then see relations between ColA and ColC, and then see relations between ColB and ColC.

I probably don't understand the 2nd part of your reply, since I don't change the headers of the columns at any point.

 

Regards,

Ayal.

 
Posted : 11/01/2022 8:12 am
(@debaser)
Posts: 838
Member Moderator
 

If you're using the data model, you can specify the number format for measures and it will apply whenever the measure is added to your pivot.

 
Posted : 11/01/2022 11:25 am
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

Hello,

It is quite possible I don’t understand what you are doing.

Do you have a sample file?

Br,
Anders

 
Posted : 11/01/2022 12:45 pm
(@Anonymous)
Posts: 0
New Member Guest
 

Hi,

 

In the attached file I want to compare Plots across the years.

If I want to compare Tons Ttl, I want to display the values with no decimal point, while if I want to compare Ton/Acre I want to see 1 decimal point.

 

Regards,

Ayal.

 
Posted : 12/01/2022 8:50 am
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

Hello,

No file got uploaded.

Br,
Anders

 
Posted : 12/01/2022 3:53 pm
(@Anonymous)
Posts: 0
New Member Guest
 

Hi

 

The awkward interface threw me off...

File is now attached.

 

Regards,

Ayal.

 
Posted : 14/01/2022 5:37 am
Share: