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)

Ned Krastev

Instructor

Posted on:

10 Aug 2021

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

How does your data get immediately formated as soon as you paste the formula into other cells

Submit an answer

related questions