2007 pivot table display data in row label

T

Tim

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
 
T

trip_to_tokyo

Format the cells as Currency and save.

Please hit Yes if my comments have helped.

Thanks.
 
R

Roger Govier

Also, right click on the PT>Table Options>uncheck Autoformat table

--
Regards
Roger Govier

trip_to_tokyo said:
Format the cells as Currency and save.

Please hit Yes if my comments have helped.

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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Top