using GETPIVOTDATA feature and need to keep formatting

  • Thread starter Thread starter CTTTTT
  • Start date Start date
C

CTTTTT

I want to copy a value from a pivot table and am combining it with text using
the =(C1&" "&(Getpivotdata....)) feature. The values in the pivot table are
monitary and I'd like to keep the $ sign and '000 comma but the formatting
disappears (ie no comma or $ sign)

Thanks
 
Back
Top