Custom Headers

[Wercs]

Hi,

I'm trying to get an Excel 2000 Header to display only the current Year.

I've looked at using &[Date], but that displays a full date, & as it's a
header there isn't a cell to format to show just the year.

&[Year] doesn't seem to work -- or have I missed something obvious?

Can anyone help. please?


TIA.

 

[Paul]

Hi,

I'm trying to get an Excel 2000 Header to display only the current Year.

I've looked at using &[Date], but that displays a full date, & as it's a
header there isn't a cell to format to show just the year.

&[Year] doesn't seem to work -- or have I missed something obvious?

As far as I know, you cannot do this without a macro. Faced with a similar
requirement in the past, I abandoned the header in favour of a formula in
row 1. You can have this row repeated at the top of each printed page if you
want, so similar results to headers are possible but with more flexibility.