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.

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.

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.

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.