2007 pivot table display data in row label

  • Thread starter Thread starter Tim
  • Start date Start date
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
 
Format the cells as Currency and save.

Please hit Yes if my comments have helped.

Thanks.
 
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
 
Back
Top