Log In
Register
Home
October 7, 2021
Offline
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.
VIP
Trusted Members
December 7, 2016
Offline
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
October 7, 2021
Offline
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.
Trusted Members
Moderators
November 1, 2018
Offline
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.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
It is quite possible I don’t understand what you are doing.
Do you have a sample file?
Br,
Anders
October 7, 2021
Offline
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.
1 Guest(s)
