| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Missing NUMBERS button in PivotTable Field Settings
I'm trying to format a field in a PivotTable row. When I right-click and
choose Field Settings, I don't see the NUMBERS button (usually located underneath the LAYOUT button). Why is this happening? I have Excel 2003, SP2. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Missing NUMBERS button in PivotTable Field Settings
see charles
In excel Pivot table is very important option i understood u r problem may be my answer is useful for u if u r not fine the numbers button then u do one thing just click the qty or total field of the pivot table and use short cut key ctrl +1 may be this is useful for u i will check another way and i will send u antoher process ok Prasad.Kakarla "Charles" wrote: I'm trying to format a field in a PivotTable row. When I right-click and choose Field Settings, I don't see the NUMBERS button (usually located underneath the LAYOUT button). Why is this happening? I have Excel 2003, SP2. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Missing NUMBERS button in PivotTable Field Settings
Thank you - I'll give it a try on Monday, if not sooner!
"Prasadkakarla" wrote: see charles In excel Pivot table is very important option i understood u r problem may be my answer is useful for u if u r not fine the numbers button then u do one thing just click the qty or total field of the pivot table and use short cut key ctrl +1 may be this is useful for u i will check another way and i will send u antoher process ok Prasad.Kakarla "Charles" wrote: I'm trying to format a field in a PivotTable row. When I right-click and choose Field Settings, I don't see the NUMBERS button (usually located underneath the LAYOUT button). Why is this happening? I have Excel 2003, SP2. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Missing NUMBERS button in PivotTable Field Settings
I just tested it. I can change the formatting however, whenever I update the
Pivot Table, it all reverts back to the original formatting. "Prasadkakarla" wrote: see charles In excel Pivot table is very important option i understood u r problem may be my answer is useful for u if u r not fine the numbers button then u do one thing just click the qty or total field of the pivot table and use short cut key ctrl +1 may be this is useful for u i will check another way and i will send u antoher process ok Prasad.Kakarla "Charles" wrote: I'm trying to format a field in a PivotTable row. When I right-click and choose Field Settings, I don't see the NUMBERS button (usually located underneath the LAYOUT button). Why is this happening? I have Excel 2003, SP2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find missing numbers in series | Excel Worksheet Functions | |||
| Excel pivot table field settings | Excel Worksheet Functions | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Extract only numbers from an alphanumeric field in Excel? | Excel Discussion (Misc queries) | |||
| How to identify a list of numbers as a publisher field | Excel Discussion (Misc queries) | |||
Linear Mode
