2007 pivot table display data in row label
 

I have data in a row label that I want displayed as currency ALL the
time....BUT...when I refresh, the data changes back to the default. Any
suggestions?
Thanks

2007 pivot table display data in row label
 

Format the cells as Currency and save.

Please hit Yes if my comments have helped.

Thanks.



"Tim" wrote:

I have data in a row label that I want displayed as currency ALL the
time....BUT...when I refresh, the data changes back to the default. Any
suggestions?
Thanks

2007 pivot table display data in row label
 

Also, right click on the PTTable Optionsuncheck Autoformat table

--
Regards
Roger Govier

"trip_to_tokyo" wrote in message
...
Format the cells as Currency and save.

Please hit Yes if my comments have helped.

Thanks.



"Tim" wrote:

I have data in a row label that I want displayed as currency ALL the
time....BUT...when I refresh, the data changes back to the default. Any
suggestions?
Thanks

__________ Information from ESET Smart Security, version of virus
signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com

2007 pivot table display data in row label
 

Hi there...tried this already, but still not displayed as currency. Thanks

"trip_to_tokyo" wrote:

Format the cells as Currency and save.

Please hit Yes if my comments have helped.

Thanks.



"Tim" wrote:

I have data in a row label that I want displayed as currency ALL the
time....BUT...when I refresh, the data changes back to the default. Any
suggestions?
Thanks