#1   Report Post  
Old December 3rd 09, 03:01 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 2
Default value field preferences

For most of my work, I want value fields in pivot tables to display as
numbers with a comma separator and no decimal points. I want to set that as
my preference in Excel (I'm using Office 2007) - is there any way I can do
that?

  #2   Report Post  
Old December 7th 09, 01:41 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default value field preferences

In EXCEL 2007 you can set up Custom Styles (set as you prefer) but you
cannot, under that functionality, set up what you want.

Please hit Yes if my comments have helped.

Thanks.

"hbecker" wrote:

For most of my work, I want value fields in pivot tables to display as
numbers with a comma separator and no decimal points. I want to set that as
my preference in Excel (I'm using Office 2007) - is there any way I can do
that?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
chart preferences 2007 rolando Charts and Charting in Excel 1 March 22nd 09 11:59 AM
preferences Vic Abrahamian Setting up and Configuration of Excel 1 February 26th 08 05:40 PM
Migrating toolbar preferences Jim Hagan Excel Discussion (Misc queries) 1 October 3rd 07 03:58 PM
Need Template to capture preferences Executive Assistant to... Excel Discussion (Misc queries) 0 April 10th 07 10:04 PM
Sort Preferences Problem Chris Excel Discussion (Misc queries) 2 June 13th 05 02:39 AM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017