PivotTable

[Guest]

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

 

[samad]

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

Please correct me if I'm wrong.
Thank

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

 

[Guest]

I tried that. Any other suggestions??

 

[samad]

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

Thanks

Sama

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