View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Prasadkakarla Prasadkakarla is offline
external usenet poster
 
Posts: 11
Default 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.