PC Review


Reply
Thread Tools Rate Thread

2007 pivot table display data in row label

 
 
Tim
Guest
Posts: n/a
 
      4th Jan 2010
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 With Quote
 
 
 
 
trip_to_tokyo
Guest
Posts: n/a
 
      4th Jan 2010
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 With Quote
 
Roger Govier
Guest
Posts: n/a
 
      4th Jan 2010
Also, right click on the PT>Table Options>uncheck Autoformat table

--
Regards
Roger Govier

"trip_to_tokyo" <(E-Mail Removed)> wrote in message
news:1AF1A63F-B082-435F-AE7C-(E-Mail Removed)...
> 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



 
Reply With Quote
 
Tim
Guest
Posts: n/a
 
      8th Jan 2010
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clear row label data in pivot table Shig Microsoft Excel Misc 2 2nd Feb 2010 05:08 PM
Display top ten items in an Office 2007 pivot table JaneH Microsoft Excel Misc 2 27th Mar 2009 04:22 PM
Excel 2007 pivot table label filter macgolfers Microsoft Excel Misc 0 22nd Aug 2008 12:54 AM
Display Row label covering multiple lines in Excel Pivot Table =?Utf-8?B?TWFydHk=?= Microsoft Excel Worksheet Functions 1 7th Apr 2006 01:56 PM
Pivot Table Label vs Orignal Data Column Name Ann Microsoft Excel Misc 2 10th Mar 2004 12:45 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:45 PM.