Hi,
This is the scenario:
- I add a number column (ColA) and format it as needed.
- I replace ColA with new Number column (ColB) and format it differently from ColA.
- I remove ColA.
- 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.
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
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.
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.
Hello,
It is quite possible I don’t understand what you are doing.
Do you have a sample file?
Br,
Anders
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.
Hello,
No file got uploaded.
Br,
Anders
Hi
The awkward interface threw me off...
File is now attached.
Regards,
Ayal.