Custom Headers

  • Thread starter Thread starter Wercs
  • Start date Start date
W

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.
 
Wercs said:
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?
Click to expand...

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.
 
Back
Top