Pivot Table Field Number

C

confused al

I would like to format the cells in the pivot table I followed the procedures
Field Settings (Pivot table field) pops up and there should be NUMBER on the
bottom right hand side of this pop up, but there is no number button at all.
What am I missing or have not done here to get number to show. Any ideas?
Cheers
 
D

Debra Dalgleish

If the source data contains text or blank cells, you won't have the
Number button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Field Formatting in Pivot Tables 1
Different ways to build Pivot table 1
Pivot Table Calculated Field - Sum/count 1
Pivot table wizards 2
Formula fields in Pivot table reports? 2
I need to turn on repeating labels in rows of my pivot table 3
Multiple listboxes to update pivot table? 2

Top