Prev: Combine an And OR function
Next: Copy IF criteria met
From: CTTTTT on 29 Apr 2010 12:03
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

From: Gary Brown on 29 Apr 2010 12:42
=(C1&" "&TEXT((Getpivotdata....),"$#,##0.00"))
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"CTTTTT" wrote:

> 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
>
 | 
Pages: 1
Prev: Combine an And OR function
Next: Copy IF criteria met