using GETPIVOTDATA feature and need to keep formatting

[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

 

[Gary Brown]

=(C1&" "&TEXT((Getpivotdata....),"$#,##0.00"))