Mark

You shouldn't need to format the date for a year. If you right-click on the
date header and select Group and show detailGroup... you will then be able
to select months and years. This will add a new field with the year in it.
If you have data from multiple years then Excel will aggregate all the
January's data for example unless you tell it to show years.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Mark Hunt" <Mark wrote in message
...
The date format appears only with the month (e.g. Jan) and not the year,
even
though I have formatted the cells to show, e.g. Jan-05.