Keep a year-only birth date as year text

Turn the birth year 2001 into the text 2001, with no made-up day or month.

What you'll make

In Excel: Birth year 2001 becomes 2001 as text.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8=""Checks whether the birth year cell is empty.Not empty
2TEXT(A8,"0000")Writes the year as text with four digits."2001"
3IF( … )Shows nothing when the year cell is empty."2001"

Read it left to right. Only the year is kept: no January 1 is made up.

=IF(A8="","",TEXT(A8,"0000"))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own years. Paste birth years into the green column of the Template tab. The year text fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Paste the year only, like 1980. A full date turns into a long number here.

Microsoft's help: TEXT function