| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table 2007 display field only in Grand Total | Excel Discussion (Misc queries) | |||
| Office 2007 Pivot Table Display format - Show row headings in each | Excel Discussion (Misc queries) | |||
| Display top ten items in an Office 2007 pivot table | Excel Discussion (Misc queries) | |||
| Excel 2007 pivot table label filter | Excel Discussion (Misc queries) | |||
| Display Row label covering multiple lines in Excel Pivot Table | Excel Worksheet Functions | |||
Hybrid Mode
