Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

2007 pivot table display data in row label

1 view
Skip to first unread message

Tim

unread,
Jan 4, 2010, 3:15:01 PM1/4/10
to
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

trip_to_tokyo

unread,
Jan 4, 2010, 3:23:02 PM1/4/10
to
Format the cells as Currency and save.

Please hit Yes if my comments have helped.

Thanks.

Roger Govier

unread,
Jan 4, 2010, 5:26:16 PM1/4/10
to
Also, right click on the PT>Table Options>uncheck Autoformat table

--
Regards
Roger Govier

"trip_to_tokyo" <in...@pierrefondes.com> wrote in message
news:1AF1A63F-B082-435F...@microsoft.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
>
>
>

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

The message was checked by ESET Smart Security.

http://www.eset.com

Tim

unread,
Jan 7, 2010, 10:38:02 PM1/7/10
to
Hi there...tried this already, but still not displayed as currency. Thanks
0 new messages