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