| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table formatting in office 2003
Right-click on a cell that you want to format, and choose Field Settings
Click the Number button Set the formatting, then click OK, click OK Douglas O''Neill wrote: I have a pivot table that uses data from a list that is formatted as a number with two decimal places. I formatted the field in the pivot table with the same format. However, when I do a refresh, it will lose the formatting and apply about 10 decimal places instead. Any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table displays data differently, Excel 2003 | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
| Formatting of Pivot table | Excel Discussion (Misc queries) | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
