How does your data get immediately formated as soon as you paste the formula into other cells
in
Data Analysis with Excel Pivot Tables
/
GetPivotData is great! Extracting data from the Master Pivot Table
I cant seem to figure out what formatting you did to get the numbers in RED with the BRACKETS as soon as you paste the formula. I follow very closely and I havent seen you show this.
1 answers ( 0 marked as helpful)
HI Nicolas,
Good to hear from you. I believe the cells were formatted off-screen and then simply pasted in these cells.
Apologies for the confusion.
Best,
Ned