PivotTable
 

Hi,
My source data has one column that contains numbers formatted as US dollars
and other data (in the same column) formatted as Euros. Is there any way I
can preserve the formatting when I create a pivotTable?
Thanks.
Vicky

PivotTable
 

Yes you can preserve formatting by click option in Pivot table wizard

Please correct me if I'm wrong.
Thanks


+-------------------------------------------------------------------+
|Filename: pivotscreen.GIF |
|Download: http://www.excelforum.com/attachment.php?postid=5164 |
+-------------------------------------------------------------------+

--
samad
------------------------------------------------------------------------
samad's Profile: http://www.excelforum.com/member.php...o&userid=23791
View this thread: http://www.excelforum.com/showthread...hreadid=569741

PivotTable
 

I tried that. Any other suggestions??

"samad" wrote:


Yes you can preserve formatting by click option in Pivot table wizard

Please correct me if I'm wrong.
Thanks


+-------------------------------------------------------------------+
|Filename: pivotscreen.GIF |
|Download: http://www.excelforum.com/attachment.php?postid=5164 |
+-------------------------------------------------------------------+

--
samad
------------------------------------------------------------------------
samad's Profile: http://www.excelforum.com/member.php...o&userid=23791
View this thread: http://www.excelforum.com/showthread...hreadid=569741

PivotTable
 

Hi Vicky
Double Click on the field button on data area then click Number button
then click on currency and format as you want. I think it helps you.
(attaching screen shot for you help)

Thanks

Samad


+-------------------------------------------------------------------+
|Filename: pivot screen.GIF |
|Download: http://www.excelforum.com/attachment.php?postid=5171 |
+-------------------------------------------------------------------+

--
samad
------------------------------------------------------------------------
samad's Profile: http://www.excelforum.com/member.php...o&userid=23791
View this thread: http://www.excelforum.com/showthread...hreadid=569741