If a field has blank cells or cells that contain text, you might not be
able to format the numbers, because that field is treated as Text data
type.

cmgedc wrote:
Excel 2007 Pivot Table - The "Number Format" option does not appear in the
field settings for one of my columns that is formatted in the data table as a
number.

It is showing up as a date format by default.

I can change the format in the pivot table to number but then each time the
Pivot Table is changed or refreshed the format reverts back to the MM-YY
format.

--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com