ExcelBanter - using GETPIVOTDATA feature and need to keep formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - using GETPIVOTDATA feature and need to keep formatting (https://www.excelbanter.com/excel-worksheet-functions/262776-using-getpivotdata-feature-need-keep-formatting.html)

CTTTTT

using GETPIVOTDATA feature and need to keep formatting

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[_6_]

using GETPIVOTDATA feature and need to keep formatting

=(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

All times are GMT +1. The time now is 01:47 AM.