View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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