The only way I've figured out how to get the fx line to read 2005 is
by saving the xls file as a text file, closing Excel and reopening
through the text import wizard. I though I could format it as Custom
= YYYY then copy/paste special and choose Values, but the fx line
remains 1/1/2005. I'm trying to create a pivot table based on yearly
amount totals, but when I drag the Date field into the Column Fields
it's creating columns based on days, not years.

Instead of showing the following
2005 2006 2007

It shows
2005 2005 2005 2005 2005 2005 2005 2005
2005 2005

One column per unique mm/dd/yyyy.

Is there an easier way to do this than saving as a txt file and going
through the import wizard?

Gracias,
El Capitan de los Snuggles