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