Ampersand operator in Header

R

RedChequer

I want to create an Excel yearly form with the only current year in the Header
Entering &d will give the current date but I only want the year. Entering
&[YEAR] or &y doesn't work. This form is to be used on a club computer in
which none of the members would be capable of creating a header by just going
to View>Headers and Footers and have the Header display 'Annual Sale 2005'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top