Display a numeric EIN as 01-2345678

Turn an EIN stored as a number, like 12345678, into the text 01-2345678.

What you'll make

In Excel: 12345678 becomes 01-2345678.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The EIN as a number, with its zero lost.12345678
2"00-0000000"The pattern: two digits, a hyphen, seven digits."00-0000000"
3TEXT( … )Adds zeros in front and puts in the hyphen."01-2345678"

The result is text, so Excel keeps the leading zero. The EINs here are made-up.

=TEXT(A8,"00-0000000")

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 IDs. Paste EIN numbers into the green column of the Template tab. The EINs with hyphens fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Use this only on a column you know holds nine-digit EINs. It adds the hyphen but doesn't check the EIN is real.

Microsoft's help: TEXT function